DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Hi all

    I have this SQL statement and it doesn't reflect my TEMP tablespace.

    select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used",round((f.free/a.total)*100) "% Free" from
    (select tablespace_name, sum(bytes/(1024*1024)) total from dba_data_files group by tablespace_name) a,
    (select tablespace_name, round(sum(bytes/(1024*1024))) used from dba_extents group by tablespace_name) u,
    (select tablespace_name, round(sum(bytes/(1024*1024))) free from dba_free_space group by tablespace_name) f
    WHERE a.tablespace_name = f.tablespace_name
    and a.tablespace_name = u.tablespace_name;

    moreover, I also noticed that if any tablespace having no objects in there, it also doesn't reflect on here.

    Anyone had any others Query or suggestions to this query??


  2. #2
    Join Date
    Jul 2000
    Do an outer join and you will see what you wish to.

  3. #3
    in 8i+, temporary file does not appear in dba_data_files , it is in dba_temp_files.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.