Show TOC

Segments Detailed Analysis (Aggregated)Locate this document in the navigation structure

Definition

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.

Use

You choose Start of the navigation path Space Next navigation step Segments Next navigation step Detailed Analysis (Aggregated) End of the navigation path 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.

Structure

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

    Note

    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