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

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.

Open

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. a new KPI group “XORA” with default description “Generated KPIs”.

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

4. A list of generated KPIs is displayed in spool output.

   Open

   

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.

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. 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 default description “Generated KPIs”.

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

5. A list of generated KPIs is displayed in spool output.

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