SAP ABAP Table GST04 (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	GST04	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	DB_NAME	☐	DB_NAME	CHAR3	CHAR	3	0	Name of database
2	DB_UP_DATE	☐	DB_UP_DATE	DATS	DATS	8	0	Date of database start
3	DB_UP_TIME	☐	DB_UP_TIME	T	TIMS	6	0	Time of database start
4	BUFSIZE	☐	GBUFSIZE	CHAR20	CHAR	20	0	Data base buffer pool size
5	BUFREADS	☐	GBUFREADS	CHAR20	CHAR	20	0	Database buffer reads
6	BUFQUAL	☐	BUFQUAL	CHAR6	CHAR	6	0	Quality of data base buffer pool
7	BUFPWRITES	☐	GBUFPWRITE	CHAR20	CHAR	20	0	Physical writes
8	BUFPREADS	☐	GBUFPREADS	CHAR20	CHAR	20	0	Physical reads
9	BUFWAITS	☐	GBUFWAITS	CHAR20	CHAR	20	0	Buffer busy waits
10	BUFWTIME	☐	GBUFWTIME	CHAR20	CHAR	20	0	Buffer busy wait time
11	DICTSIZE	☐	GDICTSIZE	CHAR20	CHAR	20	0	Dictionary cache size
12	DDQUAL	☐	DD_QUALITY	CHAR6	CHAR	6	0	Quality of Data Dictionary cache
13	GETRATIO	☐	GETRATIO	CHAR6	CHAR	6	0	Getratio of SQLAREA in ORACLE7
14	PINRATIO	☐	PINRATIO	CHAR6	CHAR	6	0	Pinratio of SQLAREA in ORACLE7
15	LOGSIZE	☐	GLOGSIZE	CHAR20	CHAR	20	0	Redo log buffer size
16	LOGENTRIES	☐	GLOGENTRIE	CHAR20	CHAR	20	0	Redo log buffer entries
17	LOGALLOC	☐	GLOGALLOC	CHAR20	CHAR	20	0	Redo log buffer allocation retries
18	LOGFAULT	☐	GLOGFAULT	CHAR20	CHAR	20	0	Allocation error rate of redo log buffer
19	USERCALLS	☐	GUSERCALLS	CHAR20	CHAR	20	0	User calls
20	RECURCALLS	☐	GRECURCALL	CHAR20	CHAR	20	0	Recursive calls
21	COMMITS	☐	GCOMMITS	CHAR20	CHAR	20	0	Commits
22	PARSES	☐	GPARSES	CHAR20	CHAR	20	0	Parses
23	ROLLBACKS	☐	GROLLBACKS	CHAR20	CHAR	20	0	Rollbacks
24	LOGWRITES	☐	GLOGWRITES	CHAR20	CHAR	20	0	Redo log writes
25	LOGWTIME	☐	GLOGWTIME	CHAR20	CHAR	20	0	Redo log write time
26	LOGBLOCKS	☐	GLOGBLOCKS	CHAR20	CHAR	20	0	Redo log blocks written
27	LOGWSIZE	☐	GLOGWSIZE	CHAR20	CHAR	20	0	Redo log write size
28	LOGLATCH	☐	GLOGLATCH	CHAR20	CHAR	20	0	Redo log latching time
29	SCANSHORT	☐	GSCANSHORT	CHAR20	CHAR	20	0	Short table scans
30	SCANLONG	☐	GSCANLONG	CHAR20	CHAR	20	0	Long table scans
31	SCANROWS	☐	GSCANROWS	CHAR20	CHAR	20	0	Table scan rows
32	SCANBLOCKS	☐	GSCANBLOCK	CHAR20	CHAR	20	0	Table scan blocks
33	FETCHROWID	☐	GFETCHROWI	CHAR20	CHAR	20	0	Table fetch by row ID
34	FETCHCONT	☐	GFETCHCONT	CHAR20	CHAR	20	0	Table fetch continued row
35	SORTMEM	☐	GSORTMEM	CHAR20	CHAR	20	0	Sort memory
36	SORTDISK	☐	GSORTDISK	CHAR20	CHAR	20	0	Sort disk
37	SORTROWS	☐	GSORTROWS	CHAR20	CHAR	20	0	Sort rows
38	CPUUSAGE	☐	GCPUUSAGE	CHAR20	CHAR	20	0	Database CPU usage
39	CPUCALLS	☐	GCPUCALLS	CHAR20	CHAR	20	0	CPU usage when call started
40	CPURECURS	☐	GCPURECURS	CHAR20	CHAR	20	0	Recursive CPU usage
41	CPUPARSE	☐	GCPUPARSE	CHAR20	CHAR	20	0	Parse Time CPU
42	USERTOREC	☐	USERTOREC	CHAR5	CHAR	5	0	ratio of user to recursive calls in oracle 7 monitor
43	READCALLRA	☐	READCALLRA	CHAR5	CHAR	5	0	ratio of reads to user calls in 0racle 7
44	DD_GETS	☐	GDD_GETS	CHAR24	CHAR	24	0	v$rowcache.gets
45	DD_GET_MIS	☐	GDD_GETMIS	CHAR24	CHAR	24	0	v$rowcache.getmisses
46	CONSISTGET	☐	GCONSIGETS	CHAR24	CHAR	24	0	consistent gets
47	GLOBLCKCON	☐	GGLOLCKCON	CHAR24	CHAR	24	0	Global lock converts
48	LCKHITRATI	☐	LCKHITRATI	CHAR6	CHAR	6	0	Lock hit ratio
49	DBWRCROSSI	☐	GDBWRCROSI	CHAR24	CHAR	24	0	DBWR cross instance writes
50	PINGWRITES	☐	PINGWRITES	CHAR6	CHAR	6	0	Ping/write ratio

History

Last changed by/on	SAP	20130604
SAP Release Created in