SAP ABAP Table TST04OMS (liveCache: Table for Database Summary in ST04L)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-LVC (Application Component) liveCache
     ⤷ SLVC (Package) liveCache CCMS

Basic Data

Table Category	INTTAB	Structure
Structure	TST04OMS	Table Relationship Diagram
Short Description	liveCache: Table for Database Summary in ST04L

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CACHESIZE	☐	CACHESIZE	CHAR14	CHAR	14	0	SAP MaxDB: Cache Size in KB
2	CACHEACC	☐	CACHEACC	CHAR26	CHAR	26	0	SAP MaxDB: Cache Accesses
3	CACHEHITS	☐	CACHEHITS	CHAR26	CHAR	26	0	SAP MaxDB: Cache Hits
4	HITRATE	☐	HITRATE	CHAR14	CHAR	14	0	SAP DB: Cache Hit Rate (%)
5	SQLCOMM	☐	SQLCOMM	CHAR26	CHAR	26	0	SAP DB: Number of SQL Commands
6	ROLLBACKS	☐	ROLL_BACKS	CHAR26	CHAR	26	0	SAP DB: Number of Rollbacks
7	COMMITS	☐	COMMITS_	CHAR26	CHAR	26	0	SAP MaxDB: Number of Commits
8	PREPARES	☐	PREPARES	CHAR26	CHAR	26	0	SAP DB: Number of Prepares
9	EXECUTES	☐	EXECUTES	CHAR26	CHAR	26	0	SAP DB: Number of Executes
10	CREATES	☐	CREATES	CHAR26	CHAR	26	0	SAP MaxDB: Number of Created DB Objects
11	DBPROCS	☐	DBPROCS	CHAR16	CHAR	16	0	liveCache: Database procedures
12	ALTERS	☐	ALTERS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Altered DB Objects
13	DROPS	☐	DROPS	CHAR26	CHAR	26	0	SAP DB: Number of Dropped DB objects
14	SHOWS	☐	SHOWS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Shows
15	PHYREADS	☐	PHYREADS	CHAR26	CHAR	26	0	SAP DB: Number of Physical Reads
16	PHYWRITES	☐	PHYWRITES	CHAR26	CHAR	26	0	SAP DB: Number of Physical Writes
17	LOGREADS	☐	LOG_READS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Logical Reads
18	LOGWRITES	☐	LOG_WRITES	CHAR26	CHAR	26	0	SAP MaxDB: Number of Logical Writes
19	LOCKENTRY	☐	LOCKENTRY	CHAR26	CHAR	26	0	SAP DB: Available Lock Entries
20	MAXENTRIES	☐	MAXENTRIES	CHAR26	CHAR	26	0	SAP MaxDB: Maximum Used Lock Entries
21	AVGENTRIES	☐	AVGENTRIES	CHAR26	CHAR	26	0	SAP DB: Average Used Lock Entries
22	ROWENTRIES	☐	ROWENTRIES	CHAR26	CHAR	26	0	SAP DB: Number of Current Row Locks
23	TABENTRIES	☐	TABENTRIES	CHAR26	CHAR	26	0	SAP MaxDB: Number of Current Table Locks
24	COLLISION	☐	COLLISION	CHAR26	CHAR	26	0	SAP MaxDB: Lock List Collisions Since Restart
25	ESCALATION	☐	ESCALATION	CHAR26	CHAR	26	0	SAP MaxDB: Lock List Escalations Since Restart
26	LOCKHOLDER	☐	LOCKHOLDER	CHAR26	CHAR	26	0	SAP DB: Number of Transactions Holding Locks
27	LOCKREQ	☐	LOCKREQ	CHAR26	CHAR	26	0	SAP DB: Number of Transactions Requesting Locks
28	LOGPAGES	☐	LOGPAGES	CHAR26	CHAR	26	0	SAP MaxDB: Log Pages Written
29	LOGWAITS	☐	LOGWAITS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Wait Situations for Log Writer
30	GROUPCOM	☐	GROUPCOM	CHAR26	CHAR	26	0	SAP DB: Number of Group Commits
31	QUEUEOVER	☐	QUEUEOVER	CHAR26	CHAR	26	0	SAP DB: Log Queue Overflows
32	TABLESCANS	☐	TABLESCANS	CHAR26	CHAR	26	0	SAP DB: Number of Table Scans
33	INDEXSCANS	☐	INDEXSCANS	CHAR26	CHAR	26	0	SAP DB: Number of Index Scans
34	CACHESORTS	☐	CACHESORTS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Sort Operations
35	ROWSORTS	☐	ROWSORTS	CHAR26	CHAR	26	0	SAP DB: Sorted Rows

History

Last changed by/on	SAP	20130604
SAP Release Created in