Document Type | Technical Information
Category | Monitoring/Inspection
Applicable Product Versions | 6FS06, 6FS07
Document Number | TMOTI024
Overview
This explains how to check the configured autoextend size when the Autoextend on option is set for a Tablespace.
increment_by | The number of blocks to be added when autoextensible is set |
|---|---|
db_block_size | Block size set when the database was created |
Method
SQL> select increment_by from dba_data_files where file_name like '%test%'; # INCREMENT_BY 1 16,384 SQL> select name, value from vt_parameter where name like '%DB_BLOCK_SIZE%'; # NAME VALUE 1 DB_BLOCK_SIZE 8192
Calculation Method
increment_by * db_block_size (16,384 * 8,192) = 134,217,728 bytes
134,217,728 / 1024 / 1024 = 128 MB