Search the Reference Library pages:  

Oracle Segments
Version 11.1
General
Data Dictionary Views

SEG$

DBA_SEGMENTS

ALL_SEGMENTS USER_SEGMENTS
Query SELECT segment_type, tablespace_name, COUNT(*)
FROM dba_segments
GROUP BY segment_type, tablespace_name
ORDER BY 2,1;
 
Segment Types
Clusters
Index
Index Partition
Index Subpartition
LOB Index
LOB Partition
LOB Segment
LOB Subpartition
Nested Table
Rollback
Table
Table Partition
Table Subpartition
Type2 UNDO
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----