Data Element list used by SAP ABAP Table TST04 (Statistics: Structure for data base information display)
SAP ABAP Table
TST04 (Statistics: Structure for data base information display) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ARCHIVER | Oracle: Status of archive writer (stopped/started/failed) | ||
| 2 | BUFPREADS | Physical reads | ||
| 3 | BUFPWRITES | Physical writes | ||
| 4 | BUFQUAL | Quality of data base buffer pool | ||
| 5 | BUFREADS | Database buffer reads | ||
| 6 | BUFSIZE | Database Buffer Pool Size | ||
| 7 | BUFWAITS | Buffer busy waits | ||
| 8 | BUFWTIME | Buffer busy wait time | ||
| 9 | COMMITS | Commits | ||
| 10 | CONSISTGET | consistent gets | ||
| 11 | CPUCALLS | CPU usage when call started | ||
| 12 | CPUPARSE | Parse Time CPU | ||
| 13 | CPURECURS | Recursive CPU usage | ||
| 14 | CPUUSAGE | Database CPU usage | ||
| 15 | CPU_BUSY | Oracle: CPU usage by Oracle (%) | ||
| 16 | CPU_COUNT | Number of CPUs | ||
| 17 | CPU_TIME_ | Oracle: Total CPU time used by Oracle (sec) | ||
| 18 | CURR_DATE | Current date at time of query | ||
| 19 | CURR_TIME | Current time of query | ||
| 20 | DBTHREADST | DB thread status | ||
| 21 | DBWRCROSSI | DBWR cross instance writes | ||
| 22 | DB_INSTANC | Database instance (OPS) | ||
| 23 | DB_NAME | Name of database | ||
| 24 | DB_SERV | Name of database server | ||
| 25 | DB_THREAD | Database instance thread ID | ||
| 26 | DB_UP_DATE | Date of database start | ||
| 27 | DB_UP_TIME | Time of database start | ||
| 28 | DD_GETS | v$rowcache.gets | ||
| 29 | DD_GET_MIS | v$rowcache.getmisses | ||
| 30 | DD_QUALITY | Quality of Data Dictionary cache | ||
| 31 | DICTSIZE | Dictionary cache size | ||
| 32 | ELAPSED_TI | Oracle: Elapsed time since database startup (sec) | ||
| 33 | FETCHCONT | Table fetch continued row | ||
| 34 | FETCHROWID | Table fetch by row ID | ||
| 35 | GETRATIO | Getratio of SQLAREA in ORACLE7 | ||
| 36 | GLOBLCKCON | Global lock converts | ||
| 37 | LCKHITRATI | Lock hit ratio | ||
| 38 | LOGALLOC | Redo log buffer allocation retries | ||
| 39 | LOGBLOCKS | Redo log blocks written | ||
| 40 | LOGENTRIES | Redo log buffer entries | ||
| 41 | LOGFAULT | Allocation error rate of redo log buffer | ||
| 42 | LOGLATCH | Redo log latching time | ||
| 43 | LOGSIZE | Redo log buffer size | ||
| 44 | LOGWRITES | Redo log writes | ||
| 45 | LOGWSIZE | Redo log write size | ||
| 46 | LOGWTIME | Redo log write time | ||
| 47 | LOG_SWITCH | Oracle: Log_switch_wait (Archive log/Clear log/Checkpoint) | ||
| 48 | ORAVERSION | Oracle: Release | ||
| 49 | PARSES | Parses | ||
| 50 | PINGWRITES | Ping/write ratio | ||
| 51 | PINRATIO | Pinratio of SQLAREA in ORACLE7 | ||
| 52 | READCALLRA | ratio of reads to user calls in 0racle 7 | ||
| 53 | RECURCALLS | Recursive calls | ||
| 54 | REDO_PROBL | Redo log file problems (from v$logfiles) | ||
| 55 | REDO_WAIT | Redo log space wait time (s) from v$sysstat | ||
| 56 | RESP_TIME | Oracle: Time per user call (ms) | ||
| 57 | ROLLBACKS | Rollbacks | ||
| 58 | SAPDBHOST | SAPDBHOST | ||
| 59 | SCANBLOCKS | Table scan blocks | ||
| 60 | SCANLONG | Long table scans | ||
| 61 | SCANROWS | Table scan rows | ||
| 62 | SCANSHORT | Short table scans | ||
| 63 | SESS_BUSY | Oracle: Sessions busy (%) | ||
| 64 | SORTDISK | Sort disk | ||
| 65 | SORTMEM | Sort memory | ||
| 66 | SORTROWS | Sort rows | ||
| 67 | SQLRELOADS | SQL area reloads (%) from v$librarycache | ||
| 68 | USERCALLS | User calls | ||
| 69 | USERTOREC | ratio of user to recursive calls in oracle 7 monitor | ||
| 70 | WAIT_BUSY | Oracle: Busy wait time (from V$System_Event) (sec) | ||
| 71 | WAIT_TOTAL | Oracle: Total wait time (from V$System_Event) (sec) |