Oracle Tablespaces Information Viewer
Displays tablespace configuration details including block size, extent management, allocation type, segment space management, and status. Useful for storage administration and tablespace configuration review.
oraclesqlstorage-tablespacesv1.0.0
0 stars0 downloads2 views0 comments
By OracleDba • Created
Code
(19 lines)12345678910111213141516171819
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/tablespaces.sql
-- Author : Tim Hall
-- Description : Displays information about tablespaces.
-- Requirements : Access to the DBA views.
-- Call Syntax : @tablespaces
-- Last Modified: 17-AUG-2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 200
SELECT tablespace_name,
block_size,
extent_management,
allocation_type,
segment_space_management,
status
FROM dba_tablespaces
ORDER BY tablespace_name;