插敘那些sql和那些sessioin用的臨時表空間

alter database tempfile '/u01/app/oracle/create_file_dest/ORCL/datafile/o1_mf_temp_9kbppr7h_.tmp' drop
*
ERROR at line 1:
ORA-25152: TEMPFILE cannot be dropped at this time






找出佔有的session:
SELECT se.username,
       sid,
       serial#,
       sql_address,
       machine,
       program,
       tablespace,
       segtype,
       contents
  FROM v$session se,
       v$sort_usage su
WHERE se.saddr=su.session_addr;










Select sql_text  from v$sqltext 
where sql_id in
(
select sql_id from  v$tempseg_usage)
看到到底還有那些SQL語句在執行