Table name | Record ID | Record No. | Field Name | Source | Unit of Measure | Description |
|---|---|---|---|---|---|---|
resource_data | ORA_IO | 1028 | phywrt | ora | writes | Number of physical write operations |
blkchg | ora | changes | Number of database block changes | |||
blkget | ora | gets | Number of database blocks acquired | |||
phyread | ora | reads | Number of physical read operations | |||
wrtreq | ora | writes | Number of write requests | |||
congets | ora | gets | Consistent reads | |||
resource_data | ORA_QUEUE | 1029 | enqtmout | ora | timeouts | Number of enqueue operations that have timed out |
enqwt | ora | waits | Number of enqueue operation waits | |||
enqddlks | ora | deadlocks | Number of enqueue operation deadlocks | |||
enqrqt | ora | requests | Number of enqueue operation requests | |||
enqrls | ora | releases | Number of enqueue operation releases | |||
resource_data | ORA_RETR | 1031 | shtblscn | ora | scans | Number of table scans - shorttables |
lgtblscn | ora | scans | Number of table scans - longtables | |||
ctrscngt | ora | gets | Number of cluster key scan blocks acquired | |||
cltrscn | ora | scans | Number of cluster key scans | |||
memsrt | ora | sorts | Number of sorts - memory | |||
dsksrt | ora | sorts | Number of sorts - disk | |||
rowsrt | ora | sorts | Number of sorts - lines | |||
resource_data | ORA_TSS | 1032 | tsall | ora | Mbytes | Total space allocated to tables |
tsused | ora | Mbytes | Total space allocated to each table | |||
tsfree | ora | Mbytes | Total free table space | |||
resource_data | ORA_RC | 1038 | rcgets | ora | gets | Number of reads from the cache |
rcmisses | ora | misses | Number of failed reads from the cache | |||
resource_data | ORA_LC | 1039 | lcexec | ora | execs | Number of cache execs |
lcreload | ora | reloads | Number of cache reloads | |||
resource_data | ORA_LT | 1040 | ltget | ora | gets | Number of latch gets |
ltmiss | ora | misses | Number of latch misses | |||
resource_data | ORA_RBS | 1043 | rbsexts | ora | extents | Number of extents occupied by rollback segments |
rbsgets | ora | gets | Number of gets obtained by rollback segments | |||
rbswaits | ora | waits | Number of waits obtained by rollback segments | |||
resource_data | ORA_USR | 1027 | curlog | ora | logons | Number of users currently logged on |
cumlog | ora | logons | Total number of users that have logged on | |||
curcsor | ora | cursors | Current number of open cursors | |||
cumcsor | ora | cursors | Total number of open cursors | |||
usrcmts | ora | commits | Number of user commits | |||
usrrlbk | ora | rollbacks | Number of user rollbacks | |||
usrcalls | ora | calls | Number of user calls | |||
resource_data | ORA_MEMORY | 1030 | ugamem | ora | number | Session UGA memory |
ugamemax | ora | number | Maximum value for section UGA memory | |||
pgamem | ora | number | Session PGA memory | |||
pgamemax | ora | number | Maximum value for section PGA memory | |||
resource_data | ORA_TSF | 1033 | blkall | ora | blocks | Total free space for each table <For dictionary management tablespaces > |
blkavl | ora | blocks | Total available table space <For dictionary management tablespaces> | |||
tsext | ora | pieces | Number of pieces of the table space fragmented <<For dictionary management tablespaces> | |||
tsmax | ora | blocks | Size of the biggest fragment <<For dictionary management tablespaces> | |||
tsmin | ora | blocks | Size of the smallest fragment <<For dictionary management tablespaces> | |||
tsavg | ora | blocks | Average size of a fragment<<For dictionary management tablespaces> | |||
tsdead | ora | blocks | Total amount of unusable space <<For dictionary management tablespaces> | |||
resource_data | ORA_OSE | 1034 | iniext | ora | Kbytes | Total amount of space initially allocated to the object |
nxtext | ora | Kbytes | Total amount of space needed for the next extent of object size | |||
totsz | ora | Kbytes | Current size of the object | |||
totext | ora | extents | Total number of extents made | |||
resource_data | ORA_DFS | 1035 | dfbytes | ora | Mbytes | Amount of space used by Oracle data files |
dfblocks | ora | blocks | Number of blocks used by Oracle data files | |||
dffile | ora | File ID and data file name | ||||
resource_data | ORA_FS | 1036 | fsbytes | ora | Mbytes | Total amount of space available for table spaces |
fsmbytes | ora | bytes | Maximum amount of space available for table spaces | |||
fsblocks | ora | blocks | Number of blocks available for table space | |||
resource_data | ORA_SEGS | 1037 | ssbytes | ora | bytes | Number of DBA segments used |
ssblocks | ora | blocks | Number of blocks for DBA segments | |||
ssexts | ora | extents r | Number of DBA segment extents | |||
ssnext | ora | bytes | Size of the next segment | |||
ssname | ora | Segment name: segment type of the DBA segment | ||||
resource_data | ORA_REDO | 1041 | redoval | ora | redos | Number of redo requests/waits |
resource_data | ORA_WAIT | 1042 | waitval | ora | headers | Number of wait headers |
resource_data | ORA_FMEM | 1044 | fmemfree | ora | bytes | Available memory |
