Database Size
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Database Size

  1. #1
    Join Date
    Jun 2003
    Posts
    108

    Database Size

    Hi DBAs,

    How to know my Database size.

    My used space comes around 2.3 GB from v$datafile.

    Can i take this as my database size.

    Pls let me know.

    Thanx in advance.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    My simple mathematic is

    select sum(bytes)/1024/1024 Database_size_MB from dba_data_files;
    Last edited by Thomasps; 01-08-2004 at 03:58 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    and v$logfile and v$control_file

    maybe also the size of you password file and spfile / init.ora file

  4. #4
    Join Date
    Jun 2003
    Posts
    108
    Hi Thomas,

    It shows like this....


    Size in MB
    15743.994

    So can i take my DB size is 15.74 GB.

    Because this is my management requirement.

    Thanx


  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Yes. Or you can get accurate value by
    Code:
    select sum(bytes)/1024/1024/1024 Database_size_GB
    from dba_data_files;
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Jun 2003
    Posts
    108
    Yes i got exactly 15.374994 GB.

    So informed them which is 15.37 GB.

    Thanx

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    but you are forgetting redlog files control files and temp files

    they are a part of your database, dont forget them

  8. #8
    Join Date
    Jun 2003
    Posts
    108
    Oh.... Sorry,

    I forgot to take that files into my account and i already informed
    them based on my previous query and my control file and redolog file
    come around less than 20MB. So i have no problem,

    Anyway thanx a lot Dave. Your info will be so helpful in future.
    So i will take all files in the account in my next requirement.

    Thanx

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    temp files as well, they dont appear in dba_data_files they are in dba_temp_files - chance are in your case they are small.

    p.s. Redo log seems very small though

  10. #10
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Hope we are talking about database size as is. If its just database size interms of used space it will be different based upon how much room you have left for future data growth.

    Just to say we can have 8 GB tablespace which might have 2GB worth tables.
    Reddy,Sam

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