Skip to main content
Skip table of contents

ORA_DB02_DBAHIST - Oracle Database SQL Plan History

Data Description

The ORA_DB02_DBAHIST event is used to check the shared cursor cache and related resource information for the Oracle database. It helps in analyzing SQL statements on the Oracle Database.

Potential Use Cases

This event could be used in the following scenarios:

  • Determine the total number of executions, the number of disk reads, the number of bugger gets, and the number of processed rows, etc. for SQL statements

  • Determine the related program and user for the SQL statement.

  • Determine the CPU time per execution, wait time, and memory information.

  • Can be used to find which Programs/Transactions are responsible for SQL statements taking a long time to execute and set alerts on various parameters.

SAP Navigation

Log in to the SAP ECC system (having Oracle database) and execute the transaction DBACOCKPIT. Navigate to Performance->SQL Statement Analysis->Shared Cursor Cache. Select 'DBA History' radio button and give a time range for which then data needs to be displayed.

image-20240321-042619.png

The below list will be displayed containing the Oracle DBA history SQL plan data

image-20240321-042748.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close