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

Thread: Database size

  1. #1
    Join Date
    Jul 2001
    Posts
    5

    Red face

    any one could you pls provide teh script for
    how to find
    1. The actual database size

    2.Database size estimation

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    select sum(bytes) from dba_data_files
    will give u the current size of your db. Extimate is something which you have to plan based on your application and the growth which u expect on the DB. Hope that helps.

    Cheers
    Vinit

  3. #3
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32

    Wink Find the Size of the DB

    select sum(a.bytes),sum(b.bytes),substr(c.value,1,10) ,
    (((sum(a.bytes)+sum(b.bytes)+c.value)/1024)/1024)/1024 total
    from v$log a,v$datafile b,v$parameter c
    where c.name='shared_pool_size'
    group by c.value
    /
    Felix
    DBA

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    Hi Suresh,

    Try this link

    http://dbasupport.com/forums/showthr...threadid=14113

    Regards,
    Santosh

  5. #5
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Talking

    Hi Suresh,

    Maybe this script will be handy for admin purposes.

    select a.tablespace_name,
    a.ts_size_in_MB,
    b.ts_free_space,
    round(((a.ts_size_in_MB-b.ts_free_space)/a.ts_size_in_MB)* 100,2) percentage
    from (select tablespace_name,
    round(sum(bytes)/(1024*1024)) ts_size_in_MB
    from dba_data_files
    group by tablespace_name) a,
    (select tablespace_name,
    round(sum(bytes)/(1024*1024)) ts_free_space
    from dba_free_space
    group by tablespace_name) b
    where a.tablespace_name = b.tablespace_name (+)
    order by b.ts_free_space

    tycho

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