oracle 9i 查询临时表空间占用率的sql，最好能和oem统计出来的结果一致！

oracle 9i 查询临时表空间占用率的sql，最好能和oem统计出来的结果一致！

SELECt a.tablespace_name,

TO_CHAr(NVL(b.bytes / 1024 / 1024, 0),'99,999,990.900') "Size (M)",

TO_CHAr(NVL(c.used_bytes /1024/1024, 0),'99999999.999') "Using (M)",

TO_CHAr(NVL(c.used_bytes / b.bytes * 100, 0), '990.00') "Using %"

FROM dba_tablespaces a,

(select tablespace_name, sum(bytes) bytes from dba_temp_files group by tablespace_name) b,

(select tablespace_name, sum(bytes_used) used_bytes from v$temp_extent_pool group by tablespace_name) c

WHERe a.tablespace_name = b.tablespace_name(+)

AND a.tablespace_name = c.tablespace_name(+)
AND a.contents = 'TEMPORARY'

oracle 查询最近执行过的 sql语句 select sql_text,last_load_time from v$sql order by last_load_time desc; select sql_text, last_load_time from v$sql where last_load_time is not null and sql_text like 'select%' order by last_load_time desc; select sql_text, last_load_time from v$sql where last_load_time is not null and sql_text like 'update%' order by last_load_time desc; select sql_text, last_load_time from v$sql where last_load_time is not null and last_load_time like' 14-06-09%' order by last_load_time desc;