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

Thread: DB Size

  1. #1
    Join Date
    Aug 2002
    Posts
    14

    DB Size

    How will you measure the Database Size?

    I was asked in one of the interview which I have attended. I have little confusion. Is the db size means, all the db file size or only system tablespace size?

    Can someone give explanation for this?


    - Bala.
    Bala

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    What a dumb question. "Database size" can mean raw data size, size of used blocks in tables, size of tables to high-water mark, total size of tables, tables + indexes, total size of data files, size of data files - (system+undo+temp),any of those things. Depends of the reason why you are asking.

    Actually, maybe that's the right answer.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2003
    Posts
    40
    Generally It means the sum of all datafiles including your system datafiles.

    select sum(bytes)/1024/1024 filesize_in_MB from dba_data_files;
    K.Chithra
    Oracle DBA

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by k.chithra
    Generally It means the sum of all datafiles including your system datafiles.

    select sum(bytes)/1024/1024 filesize_in_MB from dba_data_files;
    What abt the tempfiles in the case of locally managed temporary tablespaces???? Right query should be..

    select a.bytes+b.bytes from
    (select sum(bytes)/1024/1024 bytes from dba_data_files) a,
    (select sum(bytes)/1024/1024 bytes from dba_temp_files) b
    /
    -nagarjuna

  5. #5
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47

    Smile

    Hi chithra

    Database Size= datafiles+control files+Redo log Files

    Cheers
    Murali

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by dasari98
    Hi chithra

    Database Size= datafiles+control files+Redo log Files

    Cheers
    Murali
    So if I have a database with one table that contains 20 rows and I have 100 2G datafiles, my db size is 200G?
    Jeff Hunter

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by slimdave
    Depends of the reason why you are asking.

    Actually, maybe that's the right answer.
    A good reply to any management request is "What decision will you base upon this?". It's a very intelligent thing to say and, best of all, it pisses them off no end!
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  8. #8
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    db_size

    But I will calculate in a different way (for the actual database size)

    select sum(bytes)/1024/1024 "DB Size(MB)" from dba_segments;


    Thomas
    Last edited by Thomasps; 03-17-2003 at 10:20 PM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by marist89
    So if I have a database with one table that contains 20 rows and I have 100 2G datafiles, my db size is 200G?
    I have noticed that for many people it is as above, i.e., the sum of the sizes of the files. For me it is the used blocks: for example all that RMAN will backup within a full DB backup.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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