Oracle | Segments

Oracle Segments Version 21c

General Information

Dependencies

ALL_SEGMENTS	DBA_SEGMENTS	SYS_DBA_SEGS
CDB_SEGMENTS	SEG$	USER_SEGMENTS

System Privileges

Create [Any] Cluster	Create [Any] Indextype	Create [Any] Table
Create [Any] Index	Create [Any] Materialized View

Queries

Segment Count by Schema and Tablespace SELECT owner, segment_type, tablespace_name, COUNT(*) FROM dba_segments GROUP BY owner, segment_type, tablespace_name ORDER BY 2,3, 1;

Related Topics

What's New In 20c-21c

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx