SAP ABAP Table TST04 (Statistics: Structure for data base information display)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷
STUN_COMMON (Package) STUN
![](/abap/icon/s_instal.gif)
⤷
![](/abap/icon/s_b_tree.gif)
⤷
![](/abap/icon/s_pckstd.gif)
Basic Data
Table Category | INTTAB | Structure |
Structure | TST04 |
![]() |
Short Description | Statistics: Structure for data base information display |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | S | System table, maint. only by SAP, change = modification |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
![]() |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
0 | 0 | ORACLE Parallel Server instances | |||||
2 | ![]() |
DB_NAME | CHAR3 | CHAR | 3 | 0 | Name of database | ||
3 | ![]() |
DB_THREAD | CHAR8 | CHAR | 8 | 0 | Database instance thread ID | ||
4 | ![]() |
DB_INSTANC | CHAR16 | CHAR | 16 | 0 | Database instance (OPS) | ||
5 | ![]() |
DB_SERV | CHAR16 | CHAR | 16 | 0 | Name of database server | ||
6 | ![]() |
CURR_TIME | T | TIMS | 6 | 0 | Current time of query | ||
7 | ![]() |
CURR_DATE | DATS | DATS | 8 | 0 | Current date at time of query | ||
8 | ![]() |
DB_UP_TIME | T | TIMS | 6 | 0 | Time of database start | ||
9 | ![]() |
DB_UP_DATE | DATS | DATS | 8 | 0 | Date of database start | ||
10 | ![]() |
DBTHREADST | CHAR6 | CHAR | 6 | 0 | DB thread status | ||
11 | ![]() |
SAPDBHOST | CHAR32 | CHAR | 32 | 0 | SAPDBHOST | ||
12 | ![]() |
ORAVERSION | CHAR17 | CHAR | 17 | 0 | Oracle: Release | ||
13 | ![]() |
ELAPSED_TI | CHAR14 | CHAR | 14 | 0 | Oracle: Elapsed time since database startup (sec) | ||
14 | ![]() |
ARCHIVER | CHAR7 | CHAR | 7 | 0 | Oracle: Status of archive writer (stopped/started/failed) | ||
15 | ![]() |
LOG_SWITCH | CHAR11 | CHAR | 11 | 0 | Oracle: Log_switch_wait (Archive log/Clear log/Checkpoint) | ||
16 | ![]() |
BUFSIZE | CHAR14 | CHAR | 14 | 0 | Database Buffer Pool Size | ||
17 | ![]() |
BUFREADS | CHAR14 | CHAR | 14 | 0 | Database buffer reads | ||
18 | ![]() |
BUFQUAL | CHAR6 | CHAR | 6 | 0 | Quality of data base buffer pool | ||
19 | ![]() |
BUFPWRITES | CHAR14 | CHAR | 14 | 0 | Physical writes | ||
20 | ![]() |
BUFPREADS | CHAR14 | CHAR | 14 | 0 | Physical reads | ||
21 | ![]() |
BUFWAITS | CHAR14 | CHAR | 14 | 0 | Buffer busy waits | ||
22 | ![]() |
BUFWTIME | CHAR14 | CHAR | 14 | 0 | Buffer busy wait time | ||
23 | ![]() |
DICTSIZE | CHAR14 | CHAR | 14 | 0 | Dictionary cache size | ||
24 | ![]() |
DD_QUALITY | CHAR6 | CHAR | 6 | 0 | Quality of Data Dictionary cache | ||
25 | ![]() |
GETRATIO | CHAR6 | CHAR | 6 | 0 | Getratio of SQLAREA in ORACLE7 | ||
26 | ![]() |
PINRATIO | CHAR6 | CHAR | 6 | 0 | Pinratio of SQLAREA in ORACLE7 | ||
27 | ![]() |
LOGSIZE | CHAR14 | CHAR | 14 | 0 | Redo log buffer size | ||
28 | ![]() |
LOGENTRIES | CHAR14 | CHAR | 14 | 0 | Redo log buffer entries | ||
29 | ![]() |
LOGALLOC | CHAR14 | CHAR | 14 | 0 | Redo log buffer allocation retries | ||
30 | ![]() |
LOGFAULT | CHAR14 | CHAR | 14 | 0 | Allocation error rate of redo log buffer | ||
31 | ![]() |
USERCALLS | CHAR14 | CHAR | 14 | 0 | User calls | ||
32 | ![]() |
RECURCALLS | CHAR14 | CHAR | 14 | 0 | Recursive calls | ||
33 | ![]() |
COMMITS | CHAR14 | CHAR | 14 | 0 | Commits | ||
34 | ![]() |
PARSES | CHAR14 | CHAR | 14 | 0 | Parses | ||
35 | ![]() |
ROLLBACKS | CHAR14 | CHAR | 14 | 0 | Rollbacks | ||
36 | ![]() |
LOGWRITES | CHAR14 | CHAR | 14 | 0 | Redo log writes | ||
37 | ![]() |
LOGWTIME | CHAR14 | CHAR | 14 | 0 | Redo log write time | ||
38 | ![]() |
LOGBLOCKS | CHAR14 | CHAR | 14 | 0 | Redo log blocks written | ||
39 | ![]() |
LOGWSIZE | CHAR14 | CHAR | 14 | 0 | Redo log write size | ||
40 | ![]() |
LOGLATCH | CHAR14 | CHAR | 14 | 0 | Redo log latching time | ||
41 | ![]() |
SCANSHORT | CHAR14 | CHAR | 14 | 0 | Short table scans | ||
42 | ![]() |
SCANLONG | CHAR14 | CHAR | 14 | 0 | Long table scans | ||
43 | ![]() |
SCANROWS | CHAR14 | CHAR | 14 | 0 | Table scan rows | ||
44 | ![]() |
SCANBLOCKS | CHAR14 | CHAR | 14 | 0 | Table scan blocks | ||
45 | ![]() |
FETCHROWID | CHAR14 | CHAR | 14 | 0 | Table fetch by row ID | ||
46 | ![]() |
FETCHCONT | CHAR14 | CHAR | 14 | 0 | Table fetch continued row | ||
47 | ![]() |
SORTMEM | CHAR14 | CHAR | 14 | 0 | Sort memory | ||
48 | ![]() |
SORTDISK | CHAR14 | CHAR | 14 | 0 | Sort disk | ||
49 | ![]() |
SORTROWS | CHAR14 | CHAR | 14 | 0 | Sort rows | ||
50 | ![]() |
CPUUSAGE | CHAR14 | CHAR | 14 | 0 | Database CPU usage | ||
51 | ![]() |
CPUCALLS | CHAR14 | CHAR | 14 | 0 | CPU usage when call started | ||
52 | ![]() |
CPURECURS | CHAR14 | CHAR | 14 | 0 | Recursive CPU usage | ||
53 | ![]() |
CPUPARSE | CHAR14 | CHAR | 14 | 0 | Parse Time CPU | ||
54 | ![]() |
USERTOREC | CHAR5 | CHAR | 5 | 0 | ratio of user to recursive calls in oracle 7 monitor | ||
55 | ![]() |
READCALLRA | CHAR5 | CHAR | 5 | 0 | ratio of reads to user calls in 0racle 7 | ||
56 | ![]() |
DD_GETS | CHAR20 | CHAR | 20 | 0 | v$rowcache.gets | ||
57 | ![]() |
DD_GET_MIS | CHAR20 | CHAR | 20 | 0 | v$rowcache.getmisses | ||
58 | ![]() |
CONSISTGET | CHAR20 | CHAR | 20 | 0 | consistent gets | ||
59 | ![]() |
GLOBLCKCON | CHAR20 | CHAR | 20 | 0 | Global lock converts | ||
60 | ![]() |
LCKHITRATI | CHAR6 | CHAR | 6 | 0 | Lock hit ratio | ||
61 | ![]() |
DBWRCROSSI | CHAR24 | CHAR | 24 | 0 | DBWR cross instance writes | ||
62 | ![]() |
PINGWRITES | CHAR6 | CHAR | 6 | 0 | Ping/write ratio | ||
63 | ![]() |
SQLRELOADS | CHAR14 | CHAR | 14 | 0 | SQL area reloads (%) from v$librarycache | ||
64 | ![]() |
REDO_WAIT | CHAR14 | CHAR | 14 | 0 | Redo log space wait time (s) from v$sysstat | ||
65 | ![]() |
REDO_PROBL | CHAR14 | CHAR | 14 | 0 | Redo log file problems (from v$logfiles) | ||
66 | ![]() |
CPU_TIME_ | CHAR14 | CHAR | 14 | 0 | Oracle: Total CPU time used by Oracle (sec) | ||
67 | ![]() |
WAIT_TOTAL | CHAR14 | CHAR | 14 | 0 | Oracle: Total wait time (from V$System_Event) (sec) | ||
68 | ![]() |
WAIT_BUSY | CHAR14 | CHAR | 14 | 0 | Oracle: Busy wait time (from V$System_Event) (sec) | ||
69 | ![]() |
SESS_BUSY | CHAR14 | CHAR | 14 | 0 | Oracle: Sessions busy (%) | ||
70 | ![]() |
CPU_BUSY | CHAR14 | CHAR | 14 | 0 | Oracle: CPU usage by Oracle (%) | ||
71 | ![]() |
RESP_TIME | CHAR14 | CHAR | 14 | 0 | Oracle: Time per user call (ms) | ||
72 | ![]() |
CPU_COUNT | CHAR6 | CHAR | 6 | 0 | Number of CPUs |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |