Data Description

The ORA_DB02_PFOV event is used in SAP to view the overall performance status of the Oracle database supporting the SAP system.

Potential Use Cases

This event could be used in the following scenarios:

  • Visualize overall database healthy status in a dashboard.

  • Alert on abnormalities with database utilization statistics.

  • Correlate database overview statistics with other events in the environment causing a performance slowdown.

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 double-click the Enqueue Stat option. The data displayed will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

CLL_PARSECNT

Parse count

Number

CLL_RDS_PER_UCLL

Logical reads per user call

Number

CLL_RECURSIVE

Recursive calls

Number

CLL_USERCALLS

User calls

Number

CLL_USERCOMM

User commits

Number

CLL_USERROLLB

User rollbacks

Number

CLL_USR_PER_RCCLL

User calls per recursive call

Number

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

DATABUFFER_SIZE

Data buffer size in kB

Number

DBUFF_BUSYWAITS

Buffer busy waits

Number

DBUFF_LOGREADS

Logical Reads

Number

DBUFF_PHYSREADD

Physical reads (direct)

Number

DBUFF_PHYSREADDL

Physical reads (direct lob)

Number

DBUFF_PHYSREADS

Physical reads

Number

DBUFF_PHYSWRITES

Physical writes

Number

DBUFF_QUALITY

Data buffer quality

Number

DBUFF_WAITTIME

Buffer wait time in sec.

Number

DB_ELAPSED

Elapsed time since db start in sec.

Number

DB_INSTANCE

Name of the current database instance

String

DB_INST_ID

Instance ID

Number

DB_NODE

Current Database node (host name)

String

DB_RELEASE

Database release

Number

DB_SNAPDIFF

Seconds between two snapshots

Number

DB_STARTDATE

Startup date of the data base

YYYYMMDD

DB_STARTTIME

Startup time of the DB

HHMMSS

DB_STARTUP_TIMESTAMP

Startup timestamp

DD.MM.YYYY HH:MM:SS

DB_SYSDATE

System date of the data base

YYYYMMDD

DB_SYSTIME

Time from the db system time stamp

HHMMSS

DB_SYS_TIMESTAMP

Current Day and Time  from DB system

DD.MM.YYYY HH:MM:SS

EVENT_SUBTYPE

String

EVENT_TYPE

ORA_DB02_PFOV

String

IEFF_INMEM_SORT

In-memory sort ratio

Number

IEFF_PARSCPUTOTOT

Parse CPU to total CPU ratio

Number (Ratio)

IEFF_PARSTOEXEC

Parse to execute ratio

Number

IEFF_PTCPU_PTELPS

Parse time CPU to parse time elapsed

Number (Ratio)

IEFF_SOFTPARSE

Soft parse ratio

Number (Percent)

LGBF_ALLOFRAT

Allocation fault rate in %

Number

LGBF_ALLORETR

Allocation retries

Number

LGBF_ENTRIES

Log buffer entries

Number

LGBF_LOGFILES

Number of log files

Number

LGBF_LOGFUSE

Number of log files in use

Number

LGBF_REDLGWT

Redo log wait in sec.

Number

LGBF_SIZE

Log buffer size in kB

Number

NCLL_PARSECNT

number: Parse count

Number

NCLL_RDS_PER_UCLL

number: Logical reads per user call

Number

NCLL_RECURSIVE

number: Recursive calls

Number

NCLL_USERCALLS

number: User calls

Number

NCLL_USERCOMM

number: User commits

Number

NCLL_USERROLLB

number: User rollbacks

Number

NCLL_USR_PER_RCCLL

number: User calls per recursive call

Number

NCPUSESSION

number: CPU used by this session from gv$sysstat

Number

NDATABUFFER_SIZE

number: Data buffer size in kB

Number

NDBBUFSIZE_DBCACHE0

number: data buffer size if parameter db_cache_size = 0

Number

NDBBUFSIZE_DEFPOOL0

number: size of default pool if parameter db_cache_size = 0

Number

NDBUFF_BUSYWAITS

number: Buffer busy waits

Number

NDBUFF_LOGREADS

number: Logical Reads

Number

NDBUFF_PHYSREADD

number: Physical reads (direct)

Number

NDBUFF_PHYSREADDL

number: Physical reads (direct lob)

Number

NDBUFF_PHYSREADS

number: Physical reads

Number

NDBUFF_PHYSWRITES

number: Physical writes

Number

NDBUFF_QUALITY

number: Data buffer quality

Number

NDBUFF_WAITTIME

number: Buffer wait time in sec.

Number

NDB_CACHE_SIZE

number: db_cache_size from gv$parameter

Number

NELAPSETIMESEC

number: elapsed time since instance startup in [sec]

Number

NEXECUTECOUNT

number: execute count from gv$sysstat

Number

NGETHITS

number: sum(gethits) from hv$librarycache

Number

NGETS

number: sum(gets) from hv$librarycache

Number

NIEFF_INMEM_SORT

number: In-memory sort ratio

Number (Ratio)

NIEFF_PARSCPUTOTOT

number: Parse CPU to total CPU ratio

Number (Ratio)

NIEFF_PARSTOEXEC

number: Parse to execute ratio

Number (Ratio)

NIEFF_PTCPU_PTELPS

number: Parse time CPU to parse time elapsed

Number

NIEFF_SOFTPARSE

number: Soft parse ratio

Number (Ratio)

NLGBF_ALLOFRAT

number: Allocation fault rate in %

Number (Percent)

NLGBF_ALLORETR

number: Allocation retries

Number

NLGBF_ENTRIES

number: Log buffer entries

Number

NLGBF_LOGFILES

number: Number of log files

Number

NLGBF_LOGFUSE

number: Number of log files in use

Number

NLGBF_REDLGWT

number: Redo log wait in sec.

Number

NLGBF_SIZE

number: Log buffer size in kB

Number

NLOGICALIO

number: session logical reads from gv$sysstat

Number

NMEMORY_TARGET

number: MEMORY_TARGET (Oralce Rel. 11)

Number

NPARSECOUNTHARD

number: parse count (hard) from gv$sysstat

Number

NPARSECOUNTTOTAL

number: parse count (total) from gv$sysstat

Number

NPARSETIMECPU

number: parse time cpu from gv$sysstat

Number

NPARSETIMEELAPSED

number: parse time elapsed from gv$sysstat

Number

NPINHITS

number: sum(pinhits) from hv$librarycache

Number

NPINS

number: sum(pins) from hv$librarycache

Number

NRDLG_LTCHTIM

number: Latching time in sec.

Number

NRDLG_MBWRITTEN

number: Megabytes written

Number

NRDLG_OSBLCKWRT

number: OS blocks written

Number

NRDLG_WRITES

number: Redo writes

Number

NRDLG_WRTTIM

number: Redo write time in sec.

Number

NRELOADS

number: sum(reloads) from gv$librarycache

Number

NSHPL_CAQUAL

number: DD-cache quality in %

Number (Percent)

NSHPL_GETRATIO

number: SQL area getratio in %

Number (Percent)

NSHPL_PINRATIO

number: SQL area pinratio in %

Number (Percent)

NSHPL_RELOADSPINS

number: SQL area reloads / pins in %

Number (Percent)

NSHPL_SIZE

number: Shared pool size in kB

Number

NSIZE_DEFAULT_POOL

number: Size Default Pool

Number

NSIZE_KEEP_POOL

number: Size Keep Pool

Number

NSIZE_OTHERS

number: Size other pools

Number

NSORTSDISK

number: sorts (disk) from gv$sysstat

Number

NSORTSMEMORY

number: sorts (memory) from gv$sysstat

Number

NSORT_DISK

number: Sorts on disk

Number

NSORT_MEMORY

number: Sorts in memory

Number

NSORT_ROWS

number: Rows sorted

Number

NSORT_WAEXMULTP

number: Workarea execution in multipass mode

Number

NSORT_WAEXONEP

number: Workarea execution in one pass mode

Number

NSORT_WAEXOPT

number: Workarea execution in optimal mode

Number

NTABSF_FBYCONTROW

number: Table fetch by continued row

Number

NTABSF_FBYROWID

number: Table fetch by rowid

Number

NTABSF_LGTABSCAN

number: Long table scans

Number

NTABSF_SHTABSCAN

number: Short table scans

Number

NTIMS_BUSYWT

number: Busy wait time in seconds

Number

NTIMS_CPUCOUNT

number: CPU count / Number of CPUs

Number

NTIMS_CPUTIME

number: CPU time used by this session

Number

NTIMS_CPUUSAGE

number: CPU usage %

Number (Percent)

NTIMS_SESS_BUSY

number: Session busy %

Number (Percent)

NTIMS_TIM_PER_UCLL

number: Time per user call in msec.

Number

NTOTALWAITTIME

number: total wait time from gv$system_event

Number

NTOTGETMISS

number: sum(getmisses)  from gv$rowcache

Number

NTOTGETS

number: sum(gets) from gv$rowcache

Number

RDLG_LTCHTIM

Latching time in sec.

Number

RDLG_MBWRITTEN

Megabytes written

Number

RDLG_OSBLCKWRT

OS blocks written

Number

RDLG_WRITES

Redo writes

Number

RDLG_WRTTIM

Redo write time in sec.

Number

SHPL_CAQUAL

DD-cache quality in %

Number (Percent)

SHPL_GETRATIO

SQL area getratio in %

Number (Percent)

SHPL_PINRATIO

SQL area pinratio in %

Number (Percent)

SHPL_RELOADSPINS

SQL area reloads / pins in %

Number (Percent)

SHPL_SIZE

Shared pool size in kB

Number

SIZE_DEFAULT_POOL

Size Default Pool

Number

SIZE_KEEP_POOL

Size Keep Pool

Number

SIZE_OTHERS

Size other pools

Number

SORT_DISK

Sorts on disk

Number

SORT_MEMORY

Sorts in memory

Number

SORT_ROWS

Rows sorted

Number

SORT_WAEXMULTP

Workarea execution in multipass mode

Number

SORT_WAEXONEP

Workarea execution in one pass mode

Number

SORT_WAEXOPT

Workarea execution in optimal mode

Number

TABSF_FBYCONTROW

Table fetch by continued row

Number

TABSF_FBYROWID

Table fetch by rowid

Number

TABSF_LGTABSCAN

Long table scans

Number

TABSF_SHTABSCAN

Short table scans

Number

TIMS_BUSYWT

Busy wait time in seconds

Number

TIMS_CPUCOUNT

CPU count / Number of CPUs

Number

TIMS_CPUTIME

CPU time used by this session

Number

TIMS_CPUUSAGE

CPU usage %

Number (Percent)

TIMS_SESS_BUSY

Session busy %

Number (Percent)

TIMS_TIM_PER_UCLL

Time per user call in msec.

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.

+ | -