CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [197 users online]    © 2010 psoug.org