Show TOC

Segments Detailed AnalysisLocate this document in the navigation structure

Definition

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.

Use

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

    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):

    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

    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