Data Description

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.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

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.

Field Mapping

Field

Description

Unit of Measure

BLOCK_CHANGES

Block changes for this session

Number

BLOCK_GETS

Block gets for this session

Number

CLIENT_IDENTIFIER

Client identifier

String

CLIENT_INFO

Client information

String

CONSISTENT_CHANGES

Consistent Changes for this Session

Number

CONSISTENT_GETS

Consistent Gets for this Session

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EVENT

Resource or Event That the Session is Waiting For

String

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_SESS

String

INST_ID

Oracle Instance ID

Number

LOGICAL_READS

Total Block and Consistent Gets for the Session

Number

MACHINE

Operating System Machine Name

String

P1

Parameter value 1

Number

P1TEXT

Description of First Additional Parameter

String

P2

Parameter value 2

Number

P2TEXT

Description of Second Additional Parameter

String

P3

Parameter value 3

Number

P3TEXT

Description of Third Additional Parameter

String

PGA_ALLOC_MEM

PGA Allocated Memory

Number

PGA_FREEABLE_MEM

PGA Freeable Memory

Number

PGA_MAX_MEM

PGA Max Memory

Number

PGA_USED_MEM

PGA Used Memory

Number

PHYS_READS

Physical Read Operations for this Session

Number

PROCESS

Operating System Client Process ID

String

SAP_INSTANCE

Server Name

String

SECONDS_IN_WAIT

Wait Time in Seconds

Number

SID

Session ID

Number

SPID

Operating System Process ID

Number

SQL_TEXT

Start of SQL statement

String

STATUS

State of Session (Active, Inactive, Killed)

String

USERNAME

Column USERNAME in V$SESSION

String

UTCDIFF

The UTC OFFSSET in HHMMSS that the data was collected in

HHMMSS

UTCSIGN

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

WAIT_CLASS Column of v$session_wait

String

WAIT_TIME

WAIT_TIME Column of v$session_wait

Number