Results 1 to 12 of 12
  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: Size of oracle database

    Hi,

    How to find the same...(to find size of oracle databse)
    ALos where to look for database (dbf) file..

    Thanks!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    dba_data_files view will tell you what you need to know

    HTH
    Gregg

  3. #3
    Join Date
    Feb 2004
    Posts
    79
    HI Greg

    Thanks much for the quick reply
    How do I access that view(command in WIndows using Oracle 9i)

    Thanks in advance

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Run SQLPlus, logon to the database and issue the query

    sql> select file_name, bytes from dba_data_files;

    HTH
    Gregg

  5. #5
    Join Date
    Feb 2004
    Posts
    79
    Thanks again Greg!
    Finally under which directory location can I find the databse file (is it a .dbf file).
    Sorry for my questions but I am just a month into Oracle.
    Thanks in advance for your help.
    All i have done till now is create a table in my schema...so I am trying to explore where I can find the data files and their format.


    Thank you!

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    DBA_DATA_FILES .... file_name will show you the directory location and the filename of each ...

  7. #7
    Join Date
    Feb 2004
    Posts
    79
    Thanks for the reply.
    I do have yet another table though- a log table
    has a id, error text and error text2.
    The error text 2 is a large filed and may contain BLOBS of data.
    How do I find just the size occupied by this one table and not teh whole databse.
    alos separately I owuld like to calculate size of the associated synnyms indices, sequqnces, etc for the table.

    Thanks in advance!

  8. #8
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    For a specific table ...
    Current size allocated to the table is:
    select sum(bytes) from dba_extents where segment_name = 'tablename';

    See attached script for finding actual size of a table (size allocated
    and size used ...) Modify the script at the top and replace the owner
    and table_name with your objects ...

    HTH
    Gregg
    Attached Files Attached Files

  9. #9
    Join Date
    Feb 2004
    Posts
    79
    Excellent!
    Exactly what I needed
    By teh way, probably off topic, but I used to work in Greenville, Sc before moving here.
    :-)

  10. #10
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Where and who with in G'ville ???

  11. #11
    Join Date
    Feb 2004
    Posts
    79
    Originally posted by gbrabham
    Where and who with in G'ville ???
    GE...

    Thanks!

  12. #12
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Dont let it

    Dont let the forum die.

Posting Permissions

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