Oracle Segments
Version 11.2.0.2
General Information
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;
Related Topics
Clusters
Index
Index Partition
Index Subpartition
LOB Index
LOB Partition
LOB Segment
LOB Subpartition
Nested Table
Rollback
Table
Table Partition
Table Subpartition
Type2 UNDO
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated:
©
2012 Daniel A. Morgan
