1923050 - DBACockpit: New calculation of buffer quality

Symptom

This SAP Note is valid for the DBA Cockpit on Oracle.

This SAP Note corrects the calculation of the data buffer quality. The calculation is based on the Oracle performance view V$SYSSTAT. The value for "physical reads direct (lob)" is contained in the value for "physical reads direct". The following formula is therefore implemented:

Buffer quality = 100 * (1 -
                  ("physical reads" - "physical reads direct") /
                  ("session logical reads" - "physical reads direct"))

This SAP Note adjust the following two monitors accordingly:

• Performance Overview

• Performance Database

Other Terms

CL_ORA_ACTION_MM2 CL_ORA_ACTION_PDB_2

Reason and Prerequisites

Change in the calculation for buffer quality

Solution

Implement the corrections.