Oracle Tempfiles Information Viewer
Displays detailed information about Oracle tempfiles, including size, max size, autoextend settings, increment size, and status. Useful for monitoring TEMP tablespace configuration and capacity.
oraclesqlstorage-tablespacesv1.0.0
0 stars0 downloads2 views0 comments
By OracleDba • Created
Code
(21 lines)123456789101112131415161718192021
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/tempfiles.sql
-- Author : Tim Hall
-- Description : Displays information about tempfiles.
-- Requirements : Access to the V$ views.
-- Call Syntax : @tempfiles
-- Last Modified: 17-AUG-2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 200
COLUMN file_name FORMAT A70
SELECT file_id,
file_name,
ROUND(bytes/1024/1024/1024) AS size_gb,
ROUND(maxbytes/1024/1024/1024) AS max_size_gb,
autoextensible,
increment_by,
status
FROM dba_temp_files
ORDER BY file_name;