CREATE OR REPLACE VIEW "SYS".VW_EXTENTS_CHECK (BLOCKS, EXTENTS, OWNER, SEGMENT_NAME, SEGMENT_TYPE) AS SELECT owner, segment_name, segment_type, extents, blocks
FROM system.dba_segments s
WHERE
(s.segment_type = 'CLUSTER'AND EXISTS
(SELECT 'x' FROM system.dba_clusters c
WHERE c.owner = s.owner
AND c.cluster_name = s.segment_name
AND c.max_extents <= s.extents*1.2))
OR
(s.segment_type = 'TABLE' AND EXISTS
(SELECT 'x' FROM system.dba_tables t
WHERE t.owner = s.owner
AND t.table_name = s.segment_name
AND t.max_extents <= s.extents*1.2))
OR
(s.segment_type = 'INDEX' AND EXISTS
(SELECT 'x' FROM system.dba_indexes i
WHERE i.owner = s.owner
AND i.index_name = s.segment_name
AND i.max_extents <= s.extents*1.2))
OR
(s.segment_type = 'ROLLBACK' AND EXISTS
(SELECT 'x' FROM system.dba_rollback_segs r
WHERE r.owner = s.owner
AND r.segment_name = s.segment_name
AND r.max_extents <= s.extents*1.2));
------------------------------------------------------------------------------------------
CREATE OR REPLACE VIEW "SYS".VW_EXTENTS_USED (BLOCKS, EXTENTS, OWNER, SEGMENT_NAME) AS SELECT Owner, Segment_Name, Extents, Blocks
FROM system.dba_segments
WHERE segment_type = 'TABLE'
OR segment_type = 'INDEX';