(DI-2311) Generate KPIs specific for Oracle database monitoring

Owned by SNP
Nov 16, 2023
3 min read

This page describes how new specific KPIs for Oracle database monitoring can be generated manually. There are two scenarios of how these KPIs can be generated:

  1. Generate KPIs directly from the central SAP system

    • The central SAP system is communicating with the Oracle database directly through a valid DB connection to retrieve Oracle system metrics.

    • To generate KPIs from the central SAP system, execute the report /DVD/MON_ORA_SM_KPI_GEN.

  2. Generate KPIs from the remote SAP system through RFC destination

    • The central SAP system is connecting through a configured RFC destination to a remote SAP system. This remote SAP system is then communicating with the Oracle database through a configured DB connection to retrieve Oracle system metrics. These metrics are then sent back from the remote SAP system back into the central SAP system.

    • To generate KPIs from the remote SAP system, execute the report /DVD/MON_ORA_SM_KPI_GEN_RFC.

Generate KPIs directly from the central SAP system

Oracle system metrics are retrieved directly through a configured DB connection from the central SAP system. For this scenario, the following screen is displayed and only a valid DB connection must be set.

Use configured DB Connection used for the monitoring of a standalone Oracle database.

To generate new KPIs for Oracle system metrics, follow these steps:

  1. Enter a valid DB Connection name. This DB Connection must exist in table DBCON on the central SAP system.

    1. If the Oracle database is the standard database of the central SAP system, the ‘DEFAULT’ DB connection name can be used for local connections.

  2. Execute the report in non-testing mode.

  3. Report downloads the information about all predefined Oracle system metrics and based on these metrics, it creates:

    1. New KPIs with the prefix XORA_*.

    2. The new KPI group XORA with the default description Generated KPIs.

    3. The new Monitoring profile XORA_5MIN with the default description ORACLE System metrics.

    4. If you select the checkbox Write logs into the output on the selection screen, the messages about the generated KPIs are displayed in the spool output.

    5. At this point, the KPIs are generated and saved on the central SAP system.

Generate KPIs from the remote SAP system through RFC destination

Oracle system metrics are retrieved through a remote SAP system via the configured valid RFC destination and DB connection (this DB connection must be defined on the remote SAP system). For this scenario, the following screen is displayed and valid RFC Destination and DB connection must be set.

Use configured RFC Destination and DB Connection used for the monitoring of a standalone Oracle database.

To generate new KPIs for Oracle system metrics from the remote SAP system, follow these steps:

  1. Enter a valid RFC Destination for a remote SAP system.

  2. Enter a valid DB Connection name. This DB Connection must exist in table DBCON on the remote SAP system.

    1. If the Oracle database is the standard database of the remote SAP system, the ‘DEFAULT’ DB connection name can be used for local connections.

  3. Execute the report in non-testing mode.

  4. The report downloads the information about all predefined Oracle system metrics from the remote SAP system via the configured RFC destination and DB connection and sends these metrics back into the central SAP system. Based on retrieved metrics, it creates:

    1. new KPIs with the prefix XORA_*.

    2. a new KPI group “XORA” with the default description “Generated KPIs”.

    3. a new Monitoring profile “XORA_5MIN” with default description “ORACLE System metrics”

  5. If the checkbox “Write logs into the output” is selected on the selection screen, the messages about the generated KPIs are displayed in the spool output.

  6. At this point, the KPIs are generated and saved on the central SAP system.