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.
The below list will be displayed containing the Oracle DBA history SQL plan data
