Displays Temp Sort Space Currently in Use by Users
-- -- Displays the temp sort space currently in use by users. -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 50 SET LINESIZE 300 COLUMN tablespace FORMAT A20 COLUMN temp_size FORMAT A20 COLUMN sid_serial FORMAT A20 COLUMN username FORMAT A20 COLUMN program FORMAT A50 SELECT b.tablespace, ROUND(((b.blocks*p.value)/1024/1024),2)||'M' AS temp_size, a.inst_id as Instance, a.sid||','||a.serial# AS sid_serial, NVL(a.username, '(oracle)') AS username, a.program, a.status, a.sql_id FROM gv$session a, gv$sort_usage b, gv$parameter p WHERE p.name = 'db_block_size' AND a.saddr = b.session_addr AND a.inst_id=b.inst_id AND a.inst_id=p.inst_id ORDER BY b.tablespace, b.blocks /
Only works with IE
Related Scripts
- Segment Space Usage By Owner
- Shows Temporary Tablespace Usage
- Tablespace Space Usage
- View Datafile Info
- Displays Space Usage for Each Datafile
- Show the High Water Mark for a Given Table
- List the Number of Extents for All Indexes for a Given Table
- List Tables with More than One Extent
- Show Gaps in Tablespace or Specific Datafile