Database Information
Instance Name Host Name Version Status Started Uptime


Segments With More Than 50% Of Max Extents
Owner Tablespace
Name
Segment
Name
Segment
Type
Segment
Size
Next
Extent
Pct
Incr
Current
Extents
Max
Extents
Percent


Tables That Cannot Extend More Than 5 Times
Owner Tablespace
Name
Table Name Next Bytes Max Bytes Sum Bytes Current
Extents
Avail
Extents


Indexes That Cannot Extend More Than 5 Times
Owner Tablespace
Name
Index Name Next Bytes Max Bytes Sum Bytes Current
Extents
Avail
Extents


Tablespace(s) With Less Than 20% Freespace
Tablespace
Name
Bytes
Allocated
Bytes Used Percent
Used
Bytes Free Percent
Free


Tablespace Extent Information
Tablespace
Name
Largest Extent Smallest Extent Total Free Pieces


Datafile / Tablespace (Size and Location)
File Name Tablespace Datafile Size Bytes Used Percent Used


Buffer Hit Ratio
Consistent Gets DB Blk Gets Physical Reads Hit Ratio


Data Dictionary Hit Ratio
Gets Cache Misses Hit Ratio


Library Cache Hit Ratio
Executions Execution
Hits
Hit
Ratio
Misses Hit
Ratio


SGA Information
Name Value


Key INIT.ORA Parameters
Parameter Value Is Default Session Modifiable System Modifiable Is Modified