SAP ABAP Table ST04N_DATA (Data to be displayed in new ST04N)

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_DATA	Table Relationship Diagram
Short Description	Data to be displayed in new ST04N

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	Data to be displayed in new ST04N - characteristics
2	DB_INST_ID	☐	ST04N_DB_INST_ID	ORA_INST_ID	DEC	22	0	Instance ID
3	DB_INSTANCE	☐	ST04N_DB_INSTANCE	CHAR16	CHAR	16	0	Name of the current database instance
4	DB_NODE	☐	ST04N_DB_NODE	CHAR64	CHAR	64	0	Current Database node (host name)
5	DB_RELEASE	☐	ST04N_DB_RELEASE	CHAR17	CHAR	17	0	Database release
6	DB_SYS_TIMESTAMP	☐	ST04N_DB_SYS_TIMESTAMP	CHAR20	CHAR	20	0	Current Day and Time from DB system
7	DB_SYSDATE	☐	ST04N_DB_SYSDATE	SYDATS	DATS	8	0	System date of the data base
8	DB_SYSTIME	☐	ST04N_DB_SYSTIME	SYTIME	TIMS	6	0	Time from the db system time stamp
9	DB_STARTUP_TIMESTAMP	☐	ST04N_DB_STARTUP_TIMESTAMP	CHAR20	CHAR	20	0	Startup timestamp
10	DB_STARTDATE	☐	ST04N_DB_STARTDATE	SYDATS	DATS	8	0	Startup date of the data base
11	DB_STARTTIME	☐	ST04N_DB_STARTTIME	SYTIME	TIMS	6	0	Startup time of the DB
12	DB_ELAPSED	☐	ST04N_DB_ELAPSED	ST04N_NUMBER_16	DEC	16	0	Elapsed time since db start in sec.
13	DB_SNAPDIFF	☐	ST04N_DB_SNAPDIFF	ST04N_NUMBER_16	DEC	16	0	Seconds between two snapshots
14	.INCLUDE	☐				0	0	Data to be displayed in new ST04N - key figures
15	DATABUFFERSIZE	☐	ST04N_DATABUFFERSIZE	ST04N_NUMBER_16	DEC	16	0	Data buffer size in kB
16	DBUFF_QUALITY	☐	ST04N_DBUFF_QUALITY	ST04N_PERCNTG_3_1	DEC	4	1	Data buffer quality
17	DBUFF_LOGREADS	☐	ST04N_DBUFF_LOGREADS	ST04N_NUMBER_16	DEC	16	0	Logical Reads
18	DBUFF_PHYSREADS	☐	ST04N_DBUFF_PHYSREADS	ST04N_NUMBER_16	DEC	16	0	Physical reads
19	DBUFF_PHYSWRITES	☐	ST04N_DBUFF_PHYSWRITES	ST04N_NUMBER_16	DEC	16	0	Physical writes
20	DBUFF_BUSYWAITS	☐	ST04N_DBUFF_BUSYWAITS	ST04N_NUMBER_16	DEC	16	0	Buffer busy waits
21	DBUFF_WAITTIME	☐	ST04N_DBUFF_WAITTIME	ST04N_NUMBER_16	DEC	16	0	Buffer wait time in sec.
22	SHPL_SIZE	☐	ST04N_SHPL_SIZE	ST04N_NUMBER_16	DEC	16	0	Shared pool size in kB
23	SHPL_CAQUAL	☐	ST04N_SHPL_CAQUAL	ST04N_PERCNTG_3_1	DEC	4	1	DD-cache quality in %
24	SHPL_GETRATIO	☐	ST04N_SHPL_GETRATIO	ST04N_PERCNTG_3_1	DEC	4	1	SQL area getratio in %
25	SHPL_PINRATIO	☐	ST04N_SHPL_PINRATIO	ST04N_PERCNTG_3_1	DEC	4	1	SQL area pinratio in %
26	SHPL_RELOADSPINS	☐	ST04N_SHPL_RELOADSPINS	ST04N_PERCNTG_3_4	DEC	7	4	SQL area reloads / pins in %
27	LGBF_SIZE	☐	ST04N_LGBF_SIZE	ST04N_NUMBER_16	DEC	16	0	Log buffer size in kB
28	LGBF_ENTRIES	☐	ST04N_LGBF_ENTRIES	ST04N_NUMBER_16	DEC	16	0	Log buffer entries
29	LGBF_ALLORETR	☐	ST04N_LGBF_ALLORETR	ST04N_NUMBER_16	DEC	16	0	Allocation retries
30	LGBF_ALLOFRAT	☐	ST04N_LGBF_ALLFRAT	ST04N_PERCNTG_3_1	DEC	4	1	Allocation fault rate in %
31	LGBF_REDLGWT	☐	ST04N_LGBF_REDLGWT	ST04N_NUMBER_16	DEC	16	0	Redo log wait in sec.
32	LGBF_LOGFILES	☐	ST04N_LGBF_LOGFILES	ST04N_NUMBER_3	NUMC	3	0	Number of log files
33	LGBF_LOGFUSE	☐	ST04N_LGBF_LOGFUSE	ST04N_NUMBER_3	NUMC	3	0	Number of log files in use
34	CLL_USERCALLS	☐	ST04N_CLL_USERCALLS	ST04N_NUMBER_16	DEC	16	0	User calls
35	CLL_USERCOMM	☐	ST04N_CLL_USERCOMM	ST04N_NUMBER_16	DEC	16	0	User commits
36	CLL_USERROLLB	☐	ST04N_CLL_USERROLLB	ST04N_NUMBER_16	DEC	16	0	User rollbacks
37	CLL_RECURSIVE	☐	ST04N_CLL_RECURSIVE	ST04N_NUMBER_16	DEC	16	0	Recursive calls
38	CLL_PARSECNT	☐	ST04N_CLL_PARSECNT	ST04N_NUMBER_16	DEC	16	0	Parse count
39	CLL_USR_PER_RCCLL	☐	ST04N_CLL_USR_PER_RCCLL	ST04N_DEC_5_1	DEC	6	1	User calls per recursive call
40	CLL_RDS_PER_UCLL	☐	ST04N_CLL_RDS_PER_UCLL	ST04N_DEC_5_1	DEC	6	1	Logical reads per user call
41	TIMS_BUSYWT	☐	ST04N_TIMS_BUSWT	ST04N_NUMBER_16	DEC	16	0	Busy wait time in seconds
42	TIMS_CPUTIME	☐	ST04N_TIMS_CPUTIME	ST04N_NUMBER_16	DEC	16	0	CPU time used by this session
43	TIMS_TIM_PER_UCLL	☐	ST04N_TIMS_TIM_PER_UCLL		DEC	14	2	Time per user call in msec.
44	TIMS_SESS_BUSY	☐	ST04N_TIMS_SESS_BUSY	ST04N_PERCNTG_3_2	DEC	5	2	Session busy %
45	TIMS_CPUUSAGE	☐	ST04N_TIMS_CPUUSAGE	ST04N_PERCNTG_3_2	DEC	5	2	CPU usage %
46	TIMS_CPUCOUNT	☐	ST04N_TIMS_CPUCOUNT	ST04N_NUMBER_3	NUMC	3	0	CPU count / Number of CPUs
47	RDLG_WRITES	☐	ST04N_RDLG_WRITES	ST04N_NUMBER_16	DEC	16	0	Redo writes
48	RDLG_OSBLCKWRT	☐	ST04N_RDLG_OSBLCKWRT	ST04N_NUMBER_16	DEC	16	0	OS blocks written
49	RDLG_LTCHTIM	☐	ST04N_RDLG_LTCHTIM	ST04N_NUMBER_16	DEC	16	0	Latching time in sec.
50	RDLG_WRTTIM	☐	ST04N_RDLG_WRTTIM	ST04N_NUMBER_16	DEC	16	0	Redo write time in sec.
51	RDLG_MBWRITTEN	☐	ST04N_RDLG_MBWRITTEN	ST04N_NUMBER_16	DEC	16	0	Megabytes written
52	TABSF_SHTABSCAN	☐	ST04N_TABSF_SHTABSCAN	ST04N_NUMBER_16	DEC	16	0	Short table scans
53	TABSF_LGTABSCAN	☐	ST04N_TABSF_LGTABSCAN	ST04N_NUMBER_16	DEC	16	0	Long table scans
54	TABSF_FBYROWID	☐	ST04N_TABSF_FBYROWID	ST04N_NUMBER_16	DEC	16	0	Table fetch by rowid
55	TABSF_FBYCONTROW	☐	ST04N_TABSF_FBYCONTROW	ST04N_NUMBER_16	DEC	16	0	Table fetch by continued row
56	SORT_MEMORY	☐	ST04N_SORT_MEMORY	ST04N_NUMBER_16	DEC	16	0	Sorts in memory
57	SORT_DISK	☐	ST04N_SORT_DISK	ST04N_NUMBER_16	DEC	16	0	Sorts on disk
58	SORT_ROWS	☐	ST04N_SORT_ROWS	ST04N_NUMBER_16	DEC	16	0	Rows sorted
59	SORT_WAEXOPT	☐	ST04N_SORT_WAEXOPT	ST04N_NUMBER_16	DEC	16	0	Workarea execution in optimal mode
60	SORT_WAEXONEP	☐	ST04N_SORT_WAEXONEP	ST04N_NUMBER_16	DEC	16	0	Workarea execution in one pass mode
61	SORT_WAEXMULTP	☐	ST04N_SORT_WAEXMULTP	ST04N_NUMBER_16	DEC	16	0	Workarea execution in multipass mode
62	IEFF_SOFTPARSE	☐	ST04N_IEFF_SOFTPARSE	ST04N_DEC_1_4	DEC	5	4	Soft parse ratio
63	IEFF_INMEM_SORT	☐	ST04N_IEFF_INMEM_SORT	ST04N_DEC_1_4	DEC	5	4	In-memory sort ratio
64	IEFF_PARSTOEXEC	☐	ST04N_IEFF_PARSTOEXEC	ST04N_DEC_1_4	DEC	5	4	Parse to execute ratio
65	IEFF_PARSCPUTOTOT	☐	ST04N_IEFF_PARSCPUTOTOT	ST04N_DEC_1_4	DEC	5	4	Parse CPU to total CPU ratio
66	IEFF_PTCPU_PTELPS	☐	ST04N_IEFF_PTCPU_PTELPS	ST04N_DEC_1_4	DEC	5	4	Parse time CPU to parse time elapsed
67	.INCLUDE	☐				0	0	Data to be displayed in new ST04N - instance specific icons
68	LIEFF_SOFTPARSE	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
69	LIEFF_INMEM_SORT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
70	LIEFF_PARSTOEXEC	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
71	LIEFF_PARSCPUTOTOT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
72	LIEFF_PTCPU_PTELPS	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons

History

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