Database Administration (MOSC)

MOSC Banner

calculating max_size in bytes in oracle

edited Dec 24, 2014 10:00AM in Database Administration (MOSC) 2 commentsAnswered

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.

SQL> sho parameter block

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

----------

2147483645

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center