Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    none
    Posts
    4

    Unanswered: database size and instance info

    how do you find out how big your database is ?

    how do you find out how many instances your database has ?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    File size ???
    sql> select sum(bytes) from dba_data_files; --- Tablespace data

    Database Objects
    sql> select sum(bytes) from dba_extents; -- You can add and owner =
    where clause to look at specific schemas

    Instance Info:
    sql> select * From v$instance;

    HTH
    Gregg

  3. #3
    Join Date
    Mar 2004
    Location
    none
    Posts
    4
    thank you, one more question:
    how do I get the total database size in MB or in GB ?

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    sum(bytes)/1048576 --- mg

Posting Permissions

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