SAP ABAP Table ST04N_KYF (Data to be displayed in new ST04N - key figures)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ST04N_KYF	Table Relationship Diagram
Short Description	Data to be displayed in new ST04N - key figures

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	DATABUFFERSIZE	☐	ST04N_DATABUFFERSIZE	ST04N_NUMBER_16	DEC	16	0	Data buffer size in kB
2	DBUFF_QUALITY	☐	ST04N_DBUFF_QUALITY	ST04N_PERCNTG_3_1	DEC	4	1	Data buffer quality
3	DBUFF_LOGREADS	☐	ST04N_DBUFF_LOGREADS	ST04N_NUMBER_16	DEC	16	0	Logical Reads
4	DBUFF_PHYSREADS	☐	ST04N_DBUFF_PHYSREADS	ST04N_NUMBER_16	DEC	16	0	Physical reads
5	DBUFF_PHYSWRITES	☐	ST04N_DBUFF_PHYSWRITES	ST04N_NUMBER_16	DEC	16	0	Physical writes
6	DBUFF_BUSYWAITS	☐	ST04N_DBUFF_BUSYWAITS	ST04N_NUMBER_16	DEC	16	0	Buffer busy waits
7	DBUFF_WAITTIME	☐	ST04N_DBUFF_WAITTIME	ST04N_NUMBER_16	DEC	16	0	Buffer wait time in sec.
8	SHPL_SIZE	☐	ST04N_SHPL_SIZE	ST04N_NUMBER_16	DEC	16	0	Shared pool size in kB
9	SHPL_CAQUAL	☐	ST04N_SHPL_CAQUAL	ST04N_PERCNTG_3_1	DEC	4	1	DD-cache quality in %
10	SHPL_GETRATIO	☐	ST04N_SHPL_GETRATIO	ST04N_PERCNTG_3_1	DEC	4	1	SQL area getratio in %
11	SHPL_PINRATIO	☐	ST04N_SHPL_PINRATIO	ST04N_PERCNTG_3_1	DEC	4	1	SQL area pinratio in %
12	SHPL_RELOADSPINS	☐	ST04N_SHPL_RELOADSPINS	ST04N_PERCNTG_3_4	DEC	7	4	SQL area reloads / pins in %
13	LGBF_SIZE	☐	ST04N_LGBF_SIZE	ST04N_NUMBER_16	DEC	16	0	Log buffer size in kB
14	LGBF_ENTRIES	☐	ST04N_LGBF_ENTRIES	ST04N_NUMBER_16	DEC	16	0	Log buffer entries
15	LGBF_ALLORETR	☐	ST04N_LGBF_ALLORETR	ST04N_NUMBER_16	DEC	16	0	Allocation retries
16	LGBF_ALLOFRAT	☐	ST04N_LGBF_ALLFRAT	ST04N_PERCNTG_3_1	DEC	4	1	Allocation fault rate in %
17	LGBF_REDLGWT	☐	ST04N_LGBF_REDLGWT	ST04N_NUMBER_16	DEC	16	0	Redo log wait in sec.
18	LGBF_LOGFILES	☐	ST04N_LGBF_LOGFILES	ST04N_NUMBER_3	NUMC	3	0	Number of log files
19	LGBF_LOGFUSE	☐	ST04N_LGBF_LOGFUSE	ST04N_NUMBER_3	NUMC	3	0	Number of log files in use
20	CLL_USERCALLS	☐	ST04N_CLL_USERCALLS	ST04N_NUMBER_16	DEC	16	0	User calls
21	CLL_USERCOMM	☐	ST04N_CLL_USERCOMM	ST04N_NUMBER_16	DEC	16	0	User commits
22	CLL_USERROLLB	☐	ST04N_CLL_USERROLLB	ST04N_NUMBER_16	DEC	16	0	User rollbacks
23	CLL_RECURSIVE	☐	ST04N_CLL_RECURSIVE	ST04N_NUMBER_16	DEC	16	0	Recursive calls
24	CLL_PARSECNT	☐	ST04N_CLL_PARSECNT	ST04N_NUMBER_16	DEC	16	0	Parse count
25	CLL_USR_PER_RCCLL	☐	ST04N_CLL_USR_PER_RCCLL	ST04N_DEC_5_1	DEC	6	1	User calls per recursive call
26	CLL_RDS_PER_UCLL	☐	ST04N_CLL_RDS_PER_UCLL	ST04N_DEC_5_1	DEC	6	1	Logical reads per user call
27	TIMS_BUSYWT	☐	ST04N_TIMS_BUSWT	ST04N_NUMBER_16	DEC	16	0	Busy wait time in seconds
28	TIMS_CPUTIME	☐	ST04N_TIMS_CPUTIME	ST04N_NUMBER_16	DEC	16	0	CPU time used by this session
29	TIMS_TIM_PER_UCLL	☐	ST04N_TIMS_TIM_PER_UCLL		DEC	14	2	Time per user call in msec.
30	TIMS_SESS_BUSY	☐	ST04N_TIMS_SESS_BUSY	ST04N_PERCNTG_3_2	DEC	5	2	Session busy %
31	TIMS_CPUUSAGE	☐	ST04N_TIMS_CPUUSAGE	ST04N_PERCNTG_3_2	DEC	5	2	CPU usage %
32	TIMS_CPUCOUNT	☐	ST04N_TIMS_CPUCOUNT	ST04N_NUMBER_3	NUMC	3	0	CPU count / Number of CPUs
33	RDLG_WRITES	☐	ST04N_RDLG_WRITES	ST04N_NUMBER_16	DEC	16	0	Redo writes
34	RDLG_OSBLCKWRT	☐	ST04N_RDLG_OSBLCKWRT	ST04N_NUMBER_16	DEC	16	0	OS blocks written
35	RDLG_LTCHTIM	☐	ST04N_RDLG_LTCHTIM	ST04N_NUMBER_16	DEC	16	0	Latching time in sec.
36	RDLG_WRTTIM	☐	ST04N_RDLG_WRTTIM	ST04N_NUMBER_16	DEC	16	0	Redo write time in sec.
37	RDLG_MBWRITTEN	☐	ST04N_RDLG_MBWRITTEN	ST04N_NUMBER_16	DEC	16	0	Megabytes written
38	TABSF_SHTABSCAN	☐	ST04N_TABSF_SHTABSCAN	ST04N_NUMBER_16	DEC	16	0	Short table scans
39	TABSF_LGTABSCAN	☐	ST04N_TABSF_LGTABSCAN	ST04N_NUMBER_16	DEC	16	0	Long table scans
40	TABSF_FBYROWID	☐	ST04N_TABSF_FBYROWID	ST04N_NUMBER_16	DEC	16	0	Table fetch by rowid
41	TABSF_FBYCONTROW	☐	ST04N_TABSF_FBYCONTROW	ST04N_NUMBER_16	DEC	16	0	Table fetch by continued row
42	SORT_MEMORY	☐	ST04N_SORT_MEMORY	ST04N_NUMBER_16	DEC	16	0	Sorts in memory
43	SORT_DISK	☐	ST04N_SORT_DISK	ST04N_NUMBER_16	DEC	16	0	Sorts on disk
44	SORT_ROWS	☐	ST04N_SORT_ROWS	ST04N_NUMBER_16	DEC	16	0	Rows sorted
45	SORT_WAEXOPT	☐	ST04N_SORT_WAEXOPT	ST04N_NUMBER_16	DEC	16	0	Workarea execution in optimal mode
46	SORT_WAEXONEP	☐	ST04N_SORT_WAEXONEP	ST04N_NUMBER_16	DEC	16	0	Workarea execution in one pass mode
47	SORT_WAEXMULTP	☐	ST04N_SORT_WAEXMULTP	ST04N_NUMBER_16	DEC	16	0	Workarea execution in multipass mode
48	IEFF_SOFTPARSE	☐	ST04N_IEFF_SOFTPARSE	ST04N_DEC_1_4	DEC	5	4	Soft parse ratio
49	IEFF_INMEM_SORT	☐	ST04N_IEFF_INMEM_SORT	ST04N_DEC_1_4	DEC	5	4	In-memory sort ratio
50	IEFF_PARSTOEXEC	☐	ST04N_IEFF_PARSTOEXEC	ST04N_DEC_1_4	DEC	5	4	Parse to execute ratio
51	IEFF_PARSCPUTOTOT	☐	ST04N_IEFF_PARSCPUTOTOT	ST04N_DEC_1_4	DEC	5	4	Parse CPU to total CPU ratio
52	IEFF_PTCPU_PTELPS	☐	ST04N_IEFF_PTCPU_PTELPS	ST04N_DEC_1_4	DEC	5	4	Parse time CPU to parse time elapsed

History

Last changed by/on	SAP	20090218
SAP Release Created in	700