
This sub-monitor in the SAP/Oracle Database Monitor lets you display aggregated information on selected segments in the database and associated tables and indexes, partitions, and lobs, including history information and 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 |
Name of segment owner |
|
Object name |
Object name |
|
Object type |
Object type |
|
Tablespace |
Tablespace name |
|
Partitioned |
Whether segment is partitioned |
|
Lobs |
Whether segment has lobs |
|
Size [MB] |
Size in MB |
|
Extents |
Number of extents |
|
Blocks |
Number of blocks |
|
# Partitions |
Number of partitions |
|
# Lobs |
Number of lobs |
|
Compress for |
Type of compression (as of Oracle 11.2) |
|
Created |
Indicates whether the object has been created on the database (as of Oracle 11.2) |
Tables + Indexes
|
Column |
Description |
|---|---|
|
Owner |
Name of object owner |
|
Object |
Object name |
|
Object type |
Object type |
|
Tablespace |
Tablespace name |
|
Size [MB] |
Size of object in MB |
|
Extents |
Number of extents |
|
Blocks |
Number of blocks |
|
Partitioned |
Whether object is partitioned |
|
# Partitions |
Number of partitions |
|
Lobs |
Whether object has lobs |
|
# Lobs |
Number of lobs |
Partitions
|
Column |
Description |
|---|---|
|
Owner |
Name of object owner |
|
Root name |
Root name of partition |
|
Sub component name |
Subcomponent name of partition |
|
Sub component type |
Subcomponent type of partition |
|
Tablespace |
Tablespace name of partition |
|
Size [MB] |
Size of partition in MB |
|
# Extents |
Number of extents in partition |
|
# Blocks |
Number of blocks in partition |
|
Initial extents |
Number of initial extents in partition |
|
Next extents |
Number of next extents in partition |
|
Minimum extents |
Minimum number of next extents in partition |
|
Maximum extents |
Maximum number of next extents in partition |
|
Percentage increase |
Percentage increase in number of extents allocated |
|
Buffer pool |
Buffer pool of the partition |
Lobs
The information shown here is the same as the table above.
History
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 |
Name of object owner |
|
Root name |
Root name of object |
|
Type |
Segment type |
|
Chg. Size |
Change in segment size per day |
|
# Extents |
Number of extents |
|
Change in #Extents / day |
Change in number of extents per day |
|
# Blocks |
Number of blocks |
|
Change in #Blocks / day |
Change in number of blocks per day |
|
# Partitions |
Number of partitions |
|
Change in #Partitions / day |
Change in number of partitions per day |
|
# Lobs |
Number of lobs |
|
Change in #Lobs / day |
Change in number of lobs per day |