Data Description

The ORA_DB02_TBLA event is used in SAP to view the shared cursor cache from the viewpoint of the tables accessed. This helps you to identify performance problems for a table rather than for a statement, such as a missing index on a table.

Potential Use Cases

This event could be used in the following scenarios:

  • Identify opportunities where an index should be introduced for performance reasons.

  • Trend table use over time in a dashboard.

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 SQL Statement Analysis menu option. Double-click the Table Access option. The data displayed will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

BUFFER_GETS

Buffer Busy Waits

Number

BUFFGETS_PER_ROW

Buffer Gets

Number

BUFF_BUSY_W

Number of Buffer Gets per Row

Number

CACHE_HIT_RAT

Cache Hit Ratio

Number (Ratio)

CPU_TIME

CPU time (milliseconds)

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

DB_BLOCK_CHANGES

DB Block Changes

Number

DISK_READS

Number of Disk Reads

Number

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_TBLA

String

EXECUTIONS

Number of Executions

Number

GLOBAL_CACHE_CUR

Global Cache CR Blocks Served

Number

GLOB_CACHE_CR

Global Cache Current Blocks Served

Number

INST_ID

Oracle monitor: Instance ID

Number

INVALIDATIONS

Number of Invalidations

Number

ITL_WAITS

ITL waits

Number

LOAD_VERS

Loaded Versions

Number

LOGICAL_READS

Log Read Ratio

Number (Ratio)

LOG_READ_RAT

Logical Reads

Number

NB_CHILDS

Number of Childs

Number

OPENING_VERS

Opening Versions

Number

OWNER

Table Owner

String

PARSE_CALL

Parse Calls

Number

PERS_MEM

Persistent Memory

Number

PHYSICAL_READS

Physical Reads Direct

Number

PHYSICAL_WRITES

Physical Writes Direct

Number

PHYS_READS_DIR

Physical Reads

Number

PHYS_WRITES_DIR

Physical Writes

Number

ROWS_PER_EXEC

Row Lock Waits

Number

ROWS_PROC

Average Number of Rows processed per Execution

Number

ROW_LOCK_WAITS

Number of Rows Processed

Number

RUNTIME_MEM

Runtime Memory

Number

SH_MEM

Sharable Memory

Number

SORTS

Number of Sorts

Number

TABLE_NAME

Table Name

String

USER_OPEN

Users Opening

Number

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.

+ | -