SAP table TST04 (Statistics: Structure for data base information display)

Field Description Data Type Length Decimals Checktable Data Element
DB_NAME Name of database CHAR 3 0 DB_NAME
DB_THREAD Database instance thread ID CHAR 8 0 DB_THREAD
DB_INSTANC Database instance (OPS) CHAR 16 0 DB_INSTANC
DB_SERVER Name of database server CHAR 16 0 DB_SERV
CURR_TIME Current time of query TIMS 6 0 CURR_TIME
CURR_DATE Current date at time of query DATS 8 0 CURR_DATE
DB_UP_TIME Time of database start TIMS 6 0 DB_UP_TIME
DB_UP_DATE Date of database start DATS 8 0 DB_UP_DATE
THREAD_STA DB thread status CHAR 6 0 DBTHREADST
SAPDBHOST SAPDBHOST CHAR 32 0 SAPDBHOST
VERSION Oracle: Release CHAR 17 0 ORAVERSION
ELAPSED_TI Oracle: Elapsed time since database startup (sec) CHAR 14 0 ELAPSED_TI
ARCHIVER Oracle: Status of archive writer (stopped/started/failed) CHAR 7 0 ARCHIVER
LOG_SWITCH Oracle: Log_switch_wait (Archive log/Clear log/Checkpoint) CHAR 11 0 LOG_SWITCH
BUFSIZE Database Buffer Pool Size CHAR 14 0 BUFSIZE
BUFREADS Database buffer reads CHAR 14 0 BUFREADS
BUFQUAL Quality of data base buffer pool CHAR 6 0 BUFQUAL
BUFPWRITES Physical writes CHAR 14 0 BUFPWRITES
BUFPREADS Physical reads CHAR 14 0 BUFPREADS
BUFWAITS Buffer busy waits CHAR 14 0 BUFWAITS
BUFWTIME Buffer busy wait time CHAR 14 0 BUFWTIME
DICTSIZE Dictionary cache size CHAR 14 0 DICTSIZE
DDQUAL Quality of Data Dictionary cache CHAR 6 0 DD_QUALITY
GETRATIO Getratio of SQLAREA in ORACLE7 CHAR 6 0 GETRATIO
PINRATIO Pinratio of SQLAREA in ORACLE7 CHAR 6 0 PINRATIO
LOGSIZE Redo log buffer size CHAR 14 0 LOGSIZE
LOGENTRIES Redo log buffer entries CHAR 14 0 LOGENTRIES
LOGALLOC Redo log buffer allocation retries CHAR 14 0 LOGALLOC
LOGFAULT Allocation error rate of redo log buffer CHAR 14 0 LOGFAULT
USERCALLS User calls CHAR 14 0 USERCALLS
RECURCALLS Recursive calls CHAR 14 0 RECURCALLS
COMMITS Commits CHAR 14 0 COMMITS
PARSES Parses CHAR 14 0 PARSES
ROLLBACKS Rollbacks CHAR 14 0 ROLLBACKS
LOGWRITES Redo log writes CHAR 14 0 LOGWRITES
LOGWTIME Redo log write time CHAR 14 0 LOGWTIME
LOGBLOCKS Redo log blocks written CHAR 14 0 LOGBLOCKS
LOGWSIZE Redo log write size CHAR 14 0 LOGWSIZE
LOGLATCH Redo log latching time CHAR 14 0 LOGLATCH
SCANSHORT Short table scans CHAR 14 0 SCANSHORT
SCANLONG Long table scans CHAR 14 0 SCANLONG
SCANROWS Table scan rows CHAR 14 0 SCANROWS
SCANBLOCKS Table scan blocks CHAR 14 0 SCANBLOCKS
FETCHROWID Table fetch by row ID CHAR 14 0 FETCHROWID
FETCHCONT Table fetch continued row CHAR 14 0 FETCHCONT
SORTMEM Sort memory CHAR 14 0 SORTMEM
SORTDISK Sort disk CHAR 14 0 SORTDISK
SORTROWS Sort rows CHAR 14 0 SORTROWS
CPUUSAGE Database CPU usage CHAR 14 0 CPUUSAGE
CPUCALLS CPU usage when call started CHAR 14 0 CPUCALLS
CPURECURS Recursive CPU usage CHAR 14 0 CPURECURS
CPUPARSE Parse Time CPU CHAR 14 0 CPUPARSE
USERTOREC ratio of user to recursive calls in oracle 7 monitor CHAR 5 0 USERTOREC
READCALLRA ratio of reads to user calls in 0racle 7 CHAR 5 0 READCALLRA
DD_GETS v$rowcache.gets CHAR 20 0 DD_GETS
DD_GET_MIS v$rowcache.getmisses CHAR 20 0 DD_GET_MIS
CONSISTGET consistent gets CHAR 20 0 CONSISTGET
GLOBLCKCON Global lock converts CHAR 20 0 GLOBLCKCON
LCKHITRATI Lock hit ratio CHAR 6 0 LCKHITRATI
DBWRCROSSI DBWR cross instance writes CHAR 24 0 DBWRCROSSI
PINGWRITES Ping/write ratio CHAR 6 0 PINGWRITES
SQLRELOADS SQL area reloads (%) from v$librarycache CHAR 14 0 SQLRELOADS
REDO_WAIT Redo log space wait time (s) from v$sysstat CHAR 14 0 REDO_WAIT
REDO_PROBL Redo log file problems (from v$logfiles) CHAR 14 0 REDO_PROBL
CPU_TIME Oracle: Total CPU time used by Oracle (sec) CHAR 14 0 CPU_TIME_
WAIT_TOTAL Oracle: Total wait time (from V$System_Event) (sec) CHAR 14 0 WAIT_TOTAL
WAIT_BUSY Oracle: Busy wait time (from V$System_Event) (sec) CHAR 14 0 WAIT_BUSY
SESS_BUSY Oracle: Sessions busy (%) CHAR 14 0 SESS_BUSY
CPU_BUSY Oracle: CPU usage by Oracle (%) CHAR 14 0 CPU_BUSY
RESP_TIME Oracle: Time per user call (ms) CHAR 14 0 RESP_TIME
CPU_COUNT Number of CPUs CHAR 6 0 CPU_COUNT