Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Paris, France
    Posts
    9

    Question Unanswered: audit : how to calculate the size of a tablespace

    I'm making an Oracle audit tool
    I just want to know the request that permits to calculate the size of a tablespace.

    moreover, I want to know how to calculate the size of a filesytem

    thanks

  2. #2
    Join Date
    Mar 2002
    Posts
    4
    select tablespace_name, sum(bytes)/1024/1024 from dba_data_files
    group by tablespace_name;

Posting Permissions

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