SAP TST04 Table in S/4 HANA - Statistics: Structure for data base information display
TST04 is a standard SAP Table which is used to store Statistics: Structure for data base information display data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TST04 table(ECC)
Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Structure
Database Table: TST04
TST04 table structure field list
Below is the full TST04 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
DB_NAME | Name of database | DB_NAME | CHAR | 3(0) | CHAR3 | |||||
DB_THREAD | Database instance thread ID | DB_THREAD | CHAR | 8(0) | CHAR8 | |||||
DB_INSTANC | Database instance (OPS) | DB_INSTANC | CHAR | 16(0) | CHAR16 | |||||
DB_SERVER | Name of database server | DB_SERV | CHAR | 16(0) | CHAR16 | |||||
CURR_TIME | Current time of query | CURR_TIME | TIMS | 6(0) | T | |||||
CURR_DATE | Current date at time of query | CURR_DATE | DATS | 8(0) | DATS | |||||
DB_UP_TIME | Time of database start | DB_UP_TIME | TIMS | 6(0) | T | |||||
DB_UP_DATE | Date of database start | DB_UP_DATE | DATS | 8(0) | DATS | |||||
THREAD_STA | DB thread status | DBTHREADST | CHAR | 6(0) | CHAR6 | |||||
SAPDBHOST | SAPDBHOST | SAPDBHOST | CHAR | 32(0) | CHAR32 | |||||
VERSION | Oracle: Release | ORAVERSION | CHAR | 17(0) | CHAR17 | |||||
ELAPSED_TI | Oracle: Elapsed time since database startup (sec) | ELAPSED_TI | CHAR | 14(0) | CHAR14 | |||||
ARCHIVER | Oracle: Status of archive writer (stopped/started/failed) | ARCHIVER | CHAR | 7(0) | CHAR7 | |||||
LOG_SWITCH | Oracle: Log_switch_wait (Archive log/Clear log/Checkpoint) | LOG_SWITCH | CHAR | 11(0) | CHAR11 | |||||
BUFSIZE | Database Buffer Pool Size | BUFSIZE | CHAR | 14(0) | CHAR14 | |||||
BUFREADS | Database buffer reads | BUFREADS | CHAR | 14(0) | CHAR14 | |||||
BUFQUAL | Quality of data base buffer pool | BUFQUAL | CHAR | 6(0) | CHAR6 | |||||
BUFPWRITES | Physical writes | BUFPWRITES | CHAR | 14(0) | CHAR14 | |||||
BUFPREADS | Physical reads | BUFPREADS | CHAR | 14(0) | CHAR14 | |||||
BUFWAITS | Buffer busy waits | BUFWAITS | CHAR | 14(0) | CHAR14 | |||||
BUFWTIME | Buffer busy wait time | BUFWTIME | CHAR | 14(0) | CHAR14 | |||||
DICTSIZE | Dictionary cache size | DICTSIZE | CHAR | 14(0) | CHAR14 | |||||
DDQUAL | Quality of Data Dictionary cache | DD_QUALITY | CHAR | 6(0) | CHAR6 | |||||
GETRATIO | Getratio of SQLAREA in ORACLE7 | GETRATIO | CHAR | 6(0) | CHAR6 | |||||
PINRATIO | Pinratio of SQLAREA in ORACLE7 | PINRATIO | CHAR | 6(0) | CHAR6 | |||||
LOGSIZE | Redo log buffer size | LOGSIZE | CHAR | 14(0) | CHAR14 | |||||
LOGENTRIES | Redo log buffer entries | LOGENTRIES | CHAR | 14(0) | CHAR14 | |||||
LOGALLOC | Redo log buffer allocation retries | LOGALLOC | CHAR | 14(0) | CHAR14 | |||||
LOGFAULT | Allocation error rate of redo log buffer | LOGFAULT | CHAR | 14(0) | CHAR14 | |||||
USERCALLS | User calls | USERCALLS | CHAR | 14(0) | CHAR14 | |||||
RECURCALLS | Recursive calls | RECURCALLS | CHAR | 14(0) | CHAR14 | |||||
COMMITS | Commits | COMMITS | CHAR | 14(0) | CHAR14 | |||||
PARSES | Parses | PARSES | CHAR | 14(0) | CHAR14 | |||||
ROLLBACKS | Rollbacks | ROLLBACKS | CHAR | 14(0) | CHAR14 | |||||
LOGWRITES | Redo log writes | LOGWRITES | CHAR | 14(0) | CHAR14 | |||||
LOGWTIME | Redo log write time | LOGWTIME | CHAR | 14(0) | CHAR14 | |||||
LOGBLOCKS | Redo log blocks written | LOGBLOCKS | CHAR | 14(0) | CHAR14 | |||||
LOGWSIZE | Redo log write size | LOGWSIZE | CHAR | 14(0) | CHAR14 | |||||
LOGLATCH | Redo log latching time | LOGLATCH | CHAR | 14(0) | CHAR14 | |||||
SCANSHORT | Short table scans | SCANSHORT | CHAR | 14(0) | CHAR14 | |||||
SCANLONG | Long table scans | SCANLONG | CHAR | 14(0) | CHAR14 | |||||
SCANROWS | Table scan rows | SCANROWS | CHAR | 14(0) | CHAR14 | |||||
SCANBLOCKS | Table scan blocks | SCANBLOCKS | CHAR | 14(0) | CHAR14 | |||||
FETCHROWID | Table fetch by row ID | FETCHROWID | CHAR | 14(0) | CHAR14 | |||||
FETCHCONT | Table fetch continued row | FETCHCONT | CHAR | 14(0) | CHAR14 | |||||
SORTMEM | Sort memory | SORTMEM | CHAR | 14(0) | CHAR14 | |||||
SORTDISK | Sort disk | SORTDISK | CHAR | 14(0) | CHAR14 | |||||
SORTROWS | Sort rows | SORTROWS | CHAR | 14(0) | CHAR14 | |||||
CPUUSAGE | Database CPU usage | CPUUSAGE | CHAR | 14(0) | CHAR14 | |||||
CPUCALLS | CPU usage when call started | CPUCALLS | CHAR | 14(0) | CHAR14 | |||||
CPURECURS | Recursive CPU usage | CPURECURS | CHAR | 14(0) | CHAR14 | |||||
CPUPARSE | Parse Time CPU | CPUPARSE | CHAR | 14(0) | CHAR14 | |||||
USERTOREC | ratio of user to recursive calls in oracle 7 monitor | USERTOREC | CHAR | 5(0) | CHAR5 | |||||
READCALLRA | ratio of reads to user calls in 0racle 7 | READCALLRA | CHAR | 5(0) | CHAR5 | |||||
DD_GETS | v$rowcache.gets | DD_GETS | CHAR | 20(0) | CHAR20 | |||||
DD_GET_MIS | v$rowcache.getmisses | DD_GET_MIS | CHAR | 20(0) | CHAR20 | |||||
CONSISTGET | consistent gets | CONSISTGET | CHAR | 20(0) | CHAR20 | |||||
GLOBLCKCON | Global lock converts | GLOBLCKCON | CHAR | 20(0) | CHAR20 | |||||
LCKHITRATI | Lock hit ratio | LCKHITRATI | CHAR | 6(0) | CHAR6 | |||||
DBWRCROSSI | DBWR cross instance writes | DBWRCROSSI | CHAR | 24(0) | CHAR24 | |||||
PINGWRITES | Ping/write ratio | PINGWRITES | CHAR | 6(0) | CHAR6 | |||||
SQLRELOADS | SQL area reloads (%) from v$librarycache | SQLRELOADS | CHAR | 14(0) | CHAR14 | |||||
REDO_WAIT | Redo log space wait time (s) from v$sysstat | REDO_WAIT | CHAR | 14(0) | CHAR14 | |||||
REDO_PROBL | Redo log file problems (from v$logfiles) | REDO_PROBL | CHAR | 14(0) | CHAR14 | |||||
CPU_TIME | Oracle: Total CPU time used by Oracle (sec) | CPU_TIME_ | CHAR | 14(0) | CHAR14 | |||||
WAIT_TOTAL | Oracle: Total wait time (from V$System_Event) (sec) | WAIT_TOTAL | CHAR | 14(0) | CHAR14 | |||||
WAIT_BUSY | Oracle: Busy wait time (from V$System_Event) (sec) | WAIT_BUSY | CHAR | 14(0) | CHAR14 | |||||
SESS_BUSY | Oracle: Sessions busy (%) | SESS_BUSY | CHAR | 14(0) | CHAR14 | |||||
CPU_BUSY | Oracle: CPU usage by Oracle (%) | CPU_BUSY | CHAR | 14(0) | CHAR14 | |||||
RESP_TIME | Oracle: Time per user call (ms) | RESP_TIME | CHAR | 14(0) | CHAR14 | |||||
CPU_COUNT | Number of CPUs | CPU_COUNT | CHAR | 6(0) | CHAR6 |
Search for further information about these or an SAP related objects