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