The ORA_DB02_SESS event is used in SAP to check the Oracle session list and related resource information. In addition, you can see an execution plan and the SQL statement performed by a session. If a session performs an SQL statement from an ABAP program you can display the ABAP source.
Potential Use Cases
This event could be used in the following scenarios:
Alert on sessions utilizing excessive amounts of database resources
Identify SQL statement and ABAP code using the database resource to correlate back to SAP application data.
Create a dashboard to visualize database sessions.
The event will look like this in Splunk:
Log into the managed system and execute the dbacockpit transaction code. Then expand the Performance menu option on the left side of the screen, and then expand the Wait Event Analysis menu option. Double-click the Session Monitor option. The data displayed will match the data that is extracted and sent to Splunk.
Unit of Measure
Block changes for this session
Block gets for this session
Consistent Changes for this Session
Consistent Gets for this Session
The date time stamp when the information was collected
Resource or Event That the Session is Waiting For
Oracle Instance ID
Total Block and Consistent Gets for the Session
Operating System Machine Name
Parameter value 1
Description of First Additional Parameter
Parameter value 2
Description of Second Additional Parameter
Parameter value 3
Description of Third Additional Parameter
PGA Allocated Memory
PGA Freeable Memory
PGA Max Memory
PGA Used Memory
Physical Read Operations for this Session
Operating System Client Process ID
Wait Time in Seconds
Operating System Process ID
Start of SQL statement
State of Session (Active, Inactive, Killed)
Column USERNAME in V$SESSION
The UTC OFFSSET in HHMMSS that the data was collected in
The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.
+ | -
WAIT_CLASS Column of v$session_wait
WAIT_TIME Column of v$session_wait