col tablespace_name for a10
col size for a12
col sid_serial for a10
col program for a10
col username for a10
SELECT b.tablespace, ROUND(((b.blocks*p.value)/1024/1024),2)||'M' "SIZE",
a.sid||','||a.serial# SID_SERIAL, a.username, a.program
FROM sys.v_$session a,
sys.v_$sort_usage b, sys.v_$parameter p
WHERE p.name = 'db_block_size' AND a.saddr = b.session_addr
ORDER BY b.tablespace, b.blocks;
TABLESPACE SIZE SID_SERIAL USERNAME PROGRAM
------------------------------- ------------ ---------- ---------- --------------------------------------------------
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 451,1 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 582,29541 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 1M 770,5297 SYSMAN OMS
TEMP 4679M 581,3135 HMIS Toad.exe
22 rows selected.
Happy Learning .....
No comments:
Post a Comment