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