Scribd
Upload
41 views1 page

Temp Tablespace Usage Query in Oracle

Uploaded by

babitae
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
41 views1 page

Temp Tablespace Usage Query in Oracle

Uploaded by

babitae
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

-- Session usning TEMP segments

SELECT [Link],
ROUND((([Link]*[Link])/1024/1024),2)||'M' "SIZE",
[Link]||','||[Link]# SID_SERIAL,
[Link],
[Link], [Link]
FROM sys.v_$session a,
sys.v_$sort_usage b,
sys.v_$parameter p
WHERE [Link] = 'db_block_size'
AND [Link] = b.session_addr
ORDER BY [Link], [Link];

You might also like