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.

+ | -