Oracle Segments
Version 12.1.0.1

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;

Related Topics
Clusters
Index
Index Partition
Index Subpartition
LOB Index
LOB Partition
LOB Segment
LOB Subpartition
Nested Table
Object Tables
Rollback
Table
Table Partition
Table Subpartition
Type2 UNDO

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved