ORA_DB02_PFOV

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