...
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