Generating KPIs Specifically for Oracle Database Monitoring

This chapter describes how to generate new specific KPIs for Oracle database monitoring manually. There are two scenarios for generating these KPIs:

  1. Generating KPIs directly from the central SAP system:

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

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

  1. Generating KPIs from a remote SAP system via an RFC destination:

  • The central SAP system is connected through a configured RFC destination to a remote SAP system. This remote SAP system communicates with the Oracle database through a configured database connection to retrieve Oracle system metrics. These metrics are sent back from the remote SAP system to the central SAP system.

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

Generating KPIs Directly from the Central SAP System

Oracle system metrics are retrieved directly through a configured database connection from the central SAP system. For this scenario, the screen KPI generator for Oracle system metrics is displayed. Here, you must set a valid database connection name.

NOTE Use the configured database connection that is used for the monitoring of a standalone Oracle database.

Proceed as follows to generate new KPIs for Oracle system metrics:

  1. Execute the report /DVD/MON_ORA_SM_KPI_GEN.

  2. Enter a valid database connection name. This database connection must exist in the table DBCON on the central SAP system.

    If the Oracle database is the standard database of the central SAP system, you can use the database connection name DEFAULT for local connections.

  3. Click Execute to execute the report in non-testing mode.

    The report downloads the information about all predefined Oracle system metrics. Based on these metrics, it creates the following:

  • New KPIs with the prefix XORA_*.

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

  • The new monitoring profile XORA_5MIN with the default description ORACLE system metrics.

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

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

Generating KPIs from a Remote SAP System via an RFC Destination

Oracle system metrics are retrieved through a remote SAP system via the configured valid RFC destination and database connection. You must define this database connection on the remote SAP system. For this scenario, the following screen is displayed. Here, you must set a valid RFC destination and database connection.

Use the configured RFC destination and database connection that are used for the monitoring of a standalone Oracle database.

Proceed as follows to generate new KPIs for Oracle system metrics from the remote SAP system:

  1. Execute the report /DVD/MON_ORA_SM_KPI_GEN_RFC.

  2. Enter a valid RFC destination for a remote SAP system.

  3. Enter a valid database connection name. This database connection must exist in the table DBCON on the remote SAP system.

    If the Oracle database is the standard database of the remote SAP system, you can use the database connection name DEFAULT for local connections.

  4. Click Execute to execute the report in non-testing mode.

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

  • New KPIs with the prefix XORA_*.

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

  • The new monitoring profile XORA_5MIN with the default description ORACLE system metrics.

  • 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.

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