Oracle Temporary Segments Report
Displays all temporary segments grouped by owner, showing total space usage in KB. Useful for monitoring temporary space consumption and identifying users consuming TEMP storage.
oraclesqlstorage-tablespacesv1.0.0
0 stars0 downloads11 views0 comments
By OracleDba • Created
Code
(15 lines)123456789101112131415
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/temp_segments.sql
-- Author : Tim Hall
-- Description : Displays a list of all temporary segments.
-- Requirements : Access to the DBA views.
-- Call Syntax : @temp_segments
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET LINESIZE 500
SELECT owner,
Trunc(Sum(bytes)/1024) Kb
FROM dba_segments
WHERE segment_type = 'TEMPORARY'
GROUP BY owner;