DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: URGENT (to calculate database size )

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    19
    My current development system is NT and i need to move the content to Live environment in linux . i would like to know how to estimate the size of the database and create accrodingly in Live environment.


  2. #2
    Join Date
    Jun 2000
    Posts
    104
    select (((sum(blocks)*db_block_size)/1024)/1024)/1024 "Total database space (in GB)" from
    dba_segments .
    hope this helps.

  3. #3
    Join Date
    Nov 2000
    Posts
    1

    Red face

    You can also use the following query.

    select sum(bytes/1024/1024/1024) 'DB_SIZE'
    from dba_segment;

  4. #4
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    There is an excellent section in Appendix A of the Oracle8 Administrator's Guide that discusses appropriately estimating space requirements for tables, indexes and clusters.
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well summing segments size wont give you the size of database rather the space you need to store all associated datafiles, if you have tables that stores in 10K but it´s store in a segment of 10M then the size of the database would be 10M rather 10K just an example

  6. #6
    Join Date
    Sep 2000
    Posts
    14
    Why not Analyze all tables and indexes then you can sum the actual blocks used.

    Select 'Analyze table '||owner||'.'||table_name||' compute statistics; ' from dba_tables where owner not in ('SYS','SYSTEM') ;

    Spool the output and then run it.

    Do the same for all indexes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width