calculating max_size in bytes in oracle
Hello,
Please refer to below output:
SQL> create tablespace adotbs1 datafile '/u01/app/oracle/oradata/orcl/adotbs2.dbf' size 10m reuse autoextend off;
Tablespace created.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_file_multiblock_read_count integer 62
SQL> select max_size from dba_tablespaces where tablespace_name='ADOTBS';
MAX_SIZE
----------
SQL> select max_size/1024/1024 from dba_tablespaces where tablespace_name='ADOTBS1';
MAX_SIZE/1024/1024
------------------
2048
How do I interpret that what's the max size segment can occupy in terms of MB/GB?