Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Size of the Oracle Database

    Is there a way to find the size of the Oracle Database using TOAD

    Thanks
    Shankar

  2. #2
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Hi,
    As such there is no system tables from where you may see the database size. Since it is a logical boundary and for that you need to sum of the size of all the datafiles, control files and redo log files. That is the size of oracle database.

    Normally, the tablespace size is always being referred...& always being monitored...

    And in tod, i beive you can do it. If you connect with sys or system a/c. Even from any place where u may write ur query....

    Cheers,

    Kamesh Rastogi
    - KR

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sql> SELECT SUM(BYTES) FROM DBA_DATA_FILES;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Mar 2004
    Location
    Colorado
    Posts
    49
    What do you mean by the size of your Oracle database? If you are refering to how much memory (RAM) on the server it is using show sga will give you a good start (it does not report all the user process (MTS/Shared Server and/or Dedicated Server Process) If you are refering to how much storage it is consuming look at the size of all your data files. If you want to know how much data there is (I have seen databases with 200G of tablespace and about 5G of data) I usually just export the database and use the size of the export file for a rough guess.

Posting Permissions

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