CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
HOME | BROWSE | GROUPS | REFERENCE | ADD CODE | LINKS | SPONSORS
It's time to sign up for your 2010 PSOUG membership!
Click here to join PSOUG now!
Search the Reference Library pages:  
Help us help you! Take our 1-minute PSOUG survey. Free Oracle Magazines & 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
 
Contact Us • Legal Notices and Terms of Use • Privacy Statement
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [62 visitors online]    © 2009 psoug.org