Temp Management

※※

/**
临时段
*/
/******
sqlplus
set timing on
set pagesize 400
set linesize 7000
col USERNAME format a10
col OSUSER format a20
col MACHINE format a20
col PROGRAM format a20
col SEGMENT_NAME format a20
*/
select se.username,
       se.sid,
       se.serial#,
       se.MACHINE,
       se.PROGRAM,
       su.extents,
       su.blocks * to_number(rtrim(p.value))/1024/1024 as Sizi_M,
       tablespace,
       segtype,
       sql_text
  from v$sort_usage su, v$parameter p, v$session se, v$sql s
 where p.name = 'db_block_size'
   and su.session_addr = se.saddr
   and s.hash_value = su.sqlhash
   and s.address = su.sqladdr
 order by se.username, se.sid