
This sub-monitor in the SAP/Oracle Database Monitor lets you display selected segments in the database, including history information.
For the History tab, it uses a collector job to periodically retrieve data from the cluster table MONI. For the other tabs, it gathers data with an SQL statement in real time.
You choose in the DBA Cockpit.
The system prompts you to enter selection criteria for the segments. You enter selection criteria to restrict the display to the required segments. When the main grid is populated, you can double-click any row to display it in a more concise form in the Main data tab.
This screen contains the following information:
Main data:
|
Column |
Description |
|---|---|
|
Owner |
Owner name |
|
Segment Name |
Segment name |
|
Partition Name |
Partition name |
|
Type |
Segment type |
|
Tablespace |
Tablespace for segment |
|
Header File |
Number of header files |
|
Header Block |
Number of header blocks |
|
Freelists |
Number of process freelists allocated in this segment |
|
Freelist Group |
Number of freelist groups allocated in this segment |
|
Relative FNO |
Relative number of the file containing the segment header |
|
Buffer Pool |
Buffer pool |
|
Size [MB] |
Size in MB |
|
Extents |
Number of extents |
|
Blocks |
Number of blocks |
|
Initial Extents [MB] |
Size in MB of the initial extent of the segment |
|
Next Extents [MB] |
Size in MB of the next extent to be allocated to the segment |
|
Min Extents |
Number of minimum extents allowed in the segment |
|
Max Extents |
Number of maximum extents allowed in the segment |
|
PCT increase |
Percent increase in the size of the next extent to be allocated |
|
Compressed |
Number of segments of the specified segment type that are compressed to reduce disk use |
|
NoLogging |
Number of segments of the specified segment type that do not log creation or modification in the redo log file |
|
Compress for |
Type of compression (as of Oracle 11.2) |
Tables + Indexes and Partitions (the columns are identical):
|
Column |
Description |
|---|---|
|
Owner |
Owner name |
|
Segment |
Segment name |
|
Partition |
Partition name |
|
Type |
Segment type |
|
Tablespace |
Tablespace for segment |
|
Size (MB) |
Segment size in MB |
|
# Extents |
Number of extents |
|
# Blocks |
Number of blocks |
|
Initial Extents [MB] |
Size in MB of the initial extent of the segment |
|
Next Extents [MB] |
Size in MB of the next extent to be allocated to the segment |
|
Min. Extents |
Minimum number of extents allowed in the segment |
|
Max. Extents |
Maximum number of extents allowed in the segment |
|
Pct. Increase |
Percent increase in the size of the next extent to be allocated |
|
Buffer Pool |
The default buffer pool to be used for segments blocks |
The tab Extents:
|
Column |
Description |
|---|---|
|
Owner |
Owner name |
|
Segment |
Segment name |
|
Partition |
Partition name |
|
Type |
Segment type |
|
Tablespace |
Tablespace for segment |
|
Extent Id |
Extent ID |
|
File Id |
File ID |
|
Block Id |
Block ID |
|
Bytes |
Number of bytes |
|
Blocks |
Number of blocks |
|
Relative FNO |
Relative number of the file containing the segment header |
The tab Storage:
The Main Data sub-tab shows the following information:
|
Column |
Description |
|---|---|
|
Space |
|
|
Allocated space (Kb) |
Allocated space in KB |
|
Allocated blocks |
Number of allocated blocks |
|
Allocated extents |
Number of allocated extents |
|
Used blocks |
Number of blocks used |
|
Never used blocks |
Number of blocks never used |
|
Free in used blocks (%) |
Free space in used blocks as percentage |
|
Total free space (%) |
Total free space as percentage |
|
Block structure |
|
|
Block Size (Kb) |
Size of block in KB |
|
PCT free (%) |
Percentage free in block |
|
PCT used (%) |
Percentage used in block |
|
Transactions initial |
Number of initial transactions |
|
Transactions maximum |
Number of maximum transactions |
|
Header minimum (byte) |
Minimum header size in bytes |
|
Extent structure |
|
|
Initial extent (Kb) |
Size of initial extent in Kb |
|
Next extent (Kb) |
Size of next extent in Kb |
|
Min extents |
Minimum number of extents |
|
Max extents |
Maximum number of extents |
|
PCT increase (%) |
Percentage increase in extents |
|
Rows |
|
|
Total |
Total number of rows |
|
Chained |
Number of chained rows |
|
Avg. length (Bytes) |
Average row length in bytes |
|
Avg. length + header (Bytes) |
Average row length including header in bytes |
|
Avg. initial length (Bytes) |
Average initial row length in bytes |
You can also view this information graphically in the Histogram sub-tab.
The tab History contains the following information for the sub-tab Days (the columns are analogous for the sub-tabs Weeks and Months):
Each sub-tab on the History tab contains an average display separately at the top followed by detailed displays for each time period. The table below shows the average display. The detailed display is very similar.
|
Column |
Description |
|---|---|
|
Date |
Date of analysis |
|
Owner |
Owner name |
|
Name |
Segment name |
|
Partition |
Partition name |
|
Type |
Segment type |
|
Tablespace |
Tablespace for segment |
|
Size (MB) |
Segment size in MB |
|
Chg. Size/day |
Change in segment size per day |
|
# Extents |
Number of extents |
|
Chg. Extents/day |
Change in number of extents per day |
|
# Blocks |
Number of blocks |
|
Chg. Blocks/day |
Change in number of blocks per day |
|
Next Extent [MB] |
Size in MB of the next extent to be allocated to the segment |
|
Chg. Next Extent/day |
Change in size of extents per day |