PSOUG Home
Code Snippets
Oracle Lookup
Oracle Reference
Oracle Error Codes
Oracle Functions
PSOUG Forum
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 - 2025 psoug.org
-----
