SAP ABAP Table TUNEHDWQ (Statistical data re. SAP buffer & quality/hit ratios)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	INTTAB	Structure
Structure	TUNEHDWQ	Table Relationship Diagram
Short Description	Statistical data re. SAP buffer & quality/hit ratios

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Statistical data for internal SAP buffers
2	ALLOC_SIZE	☐	MEMALLOCSZ	INT4	INT4	10	0	Size of allocated address space
3	AVAIL_SIZE	☐	MEMAVAILSZ	INT4	INT4	10	0	Storage space available
4	FRAME_SIZE	☐	BFRAMESIZE	INT4	INT4	10	0	Length of the buffer frames
5	MAX_OBJCTS	☐	MAXOBJECTS	INT4	INT4	10	0	Maximum no. of objects
6	HASH_WIDTH	☐	HASHWIDTH	INT4	INT4	10	0	Width of hashing values used
7	CUT_VALUE	☐	CUTVALUE	INT4	INT4	10	0	Cut value
8	ACT_OBJCTS	☐	ACTOBJECTS	INT4	INT4	10	0	No. of active objects
9	CON_OBJCTS	☐	CONOBJECTS	INT4	INT4	10	0	No. of known objects
10	USED_SPACE	☐	ACTUSEDSPC	INT4	INT4	10	0	Storage space used by active objects
11	MAX_FRMES	☐	MAXFRAMES	INT4	INT4	10	0	Max. no. of frames available
12	ALLOC_FRMS	☐	ALLOCFRMS	INT4	INT4	10	0	Number of frames used
13	REQUEST	☐	BUFREQUEST	INT4	INT4	10	0	No. of object requests to the buffer
14	HIT	☐	HITCOUNT	INT4	INT4	10	0	No. of successful request
15	OBJ_N_FND	☐	BUFOBJNFND	INT4	INT4	10	0	No. of failed requests
16	INSERT	☐	BUFINSERTS	INT4	INT4	10	0	Number of buffer inserts
17	UPDATE	☐	BUFUPDATES	INT4	INT4	10	0	No. of object changes
18	REQ_DELETE	☐	BUFREQDEL	INT4	INT4	10	0	No. of delete requests for an object from the buffer
19	DELETE	☐	BUFDELETES	INT4	INT4	10	0	No. of invalidated objects
20	FREE_OBJCT	☐	BUFFREES	INT4	INT4	10	0	No. of objects released from the buffer
21	DB_ACCESS	☐	NODBACCESS	INT4	INT4	10	0	No. of database accesses
22	DB_ACC_SVD	☐	NODBACCSVD	INT4	INT4	10	0	No. of database accesses saved
23	REORG	☐	REORGCNT	INT4	INT4	10	0	No. of buffer compact./reorg.
24	SWAP	☐	SWAPCNT	INT4	INT4	10	0	No. of objects swapped
25	SWAP_FRAME	☐	SWAPFRMCNT	INT4	INT4	10	0	No. of frames swapped
26	SEARCH	☐	BUFSEARCH	INT4	INT4	10	0	No. of search operations
27	SEARCH_INS	☐	BUFSEARCHI	INT4	INT4	10	0	No. of search operations during roll-in
28	SUM_SIZE	☐	BUFOBJSUSZ	INT4	INT4	10	0	Sum of the sizes of the rolled-in objects
29	SUM_SIZE2	☐	BUFOBJSQSZ	INT4	INT4	10	0	Sum of sizes of rolled-in objects (power of 2)
30	MAX_SIZE	☐	BUFMAXOBJS	INT4	INT4	10	0	Maximum objet size
31	MIN_SIZE	☐	BUFMINOBJS	INT4	INT4	10	0	Minimum object size
32	REFRESH	☐	BUFREFRCNT	INT4	INT4	10	0	Counter for the number of buffer refreshes
33	SIZE_UNIT	☐	BUFSZUNIT	INT4	INT4	10	0	Unit used if # kB
34	RESERVE	☐	INT4	INT4	INT4	10	0	Natural number
35	ALLOC	☐	BUFMEMCLS	BUFMEMCLS	CHAR	1	0	Storage class
36	SMODE	☐	BUFSMODE	BUFSMODE	CHAR	1	0	Search procedure
37	UP_TIME	☐	BUFUPTIME	CHAR14	CHAR	14	0	Start time for statistics
38	LAST_REFR	☐	BUFLSTREFR	CHAR14	CHAR	14	0	Time of Last Buffer Refresh
39	NAME	☐	BUFNAME	BUFNAME	CHAR	5	0	Area name
40	.INCLUDE	☐				0	0	Qualities of SAP buffers
41	HITRATIO	☐	BUFQUAL_HR	BUFQUAL	DEC	7	4	Hit rate SAP buffer
42	DB_QUALITY	☐	BUFQUAL_DB	BUFQUAL	DEC	7	4	Quality of the SAP buffer (DB interface)

History

Last changed by/on	SAP	20130604
SAP Release Created in