how come this SQL statement does not reflect the TEMP tablespace Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how come this SQL statement does not reflect the TEMP tablespace

  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,,u.used,,round((u.used/*100) "% used",round((*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