Show TOC

Object documentationBW Analysis Locate this document in the navigation structure

 

This monitor in the SAP/Oracle DBA Cockpit lets you display SAP Business Information Warehouse (BW) objects belonging to the database.

You choose   Performance   Additional Functions   BW Analysis   in the DBA Cockpit.

Structure

The following BW object types are each highlighted using a different row color, since they are the aggregated data for each BW area:

  • PSA area

  • ODS and Changelog

  • Cubes and related

  • BW master data

  • Basis and Cross-Application

Double-click a row to display the BW objects belonging to the selected object type.

Double-click again a row to display the BW segments belonging to the selected BW object.

Double-click a BW segment displays the data below in the tabstrips.

The screen contains the following information:

  • Top screen area

    Column

    Description

    BW Area

    BW area

    BW Object Type

    BW object type

    Details

    Details

    # BW Objects

    Number of BW objects

    # BW Root Objects

    Number of BW root objects

    # Partitions

    Number of partitions

    Size [MB]

    Size in MB

    Extents

    Number of extents

    Blocks

    Number of blocks

  • Main Data

  • Partitions and LOBs

    Column

    Description

    Owner

    Name of partition or lob owner

    Root name

    Root name of partition or lob

    Sub component name

    Sub-component name of partition or lob

    Sub component type

    Sub-component type of partition or lob

    Tablespace

    Tablespace name of partition or lob

    Size [MB]

    Size of partition or lob in MB

    # Extents

    Number of extents for partition or lob

    # Blocks

    Number of blocks for partition or lob

    Initial extents

    Number of initial extents for partition or lob

    Next extents

    Number of next extents for partition or lob

    Minimum extents

    Minimum number of next extents for partition or lob

    Maximum extents

    Maximum number of extents for partition or lob

    Percentage increase

    Percentage increase in number of extents allocated

    Buffer pool

    Buffer pool of the partition