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

Basic Data

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

History

Last changed by/on	SAP	20130604
SAP Release Created in