SAP ABAP Table ORA_S_ST04_MAIN_DATA (DBACockpit: Oracle Performance Main Data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors

Basic Data

Table Category	INTTAB	Structure
Structure	ORA_S_ST04_MAIN_DATA	Table Relationship Diagram
Short Description	DBACockpit: Oracle Performance Main Data

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	DATABUFFER_SIZE	☐			CHAR	20	0
15	NDATABUFFER_SIZE	☐			DEC	20	0
16	DBUFF_QUALITY	☐			CHAR	20	0
17	NDBUFF_QUALITY	☐			DEC	19	1
18	SIZE_DEFAULT_POOL	☐			CHAR	20	0
19	NSIZE_DEFAULT_POOL	☐			DEC	20	0
20	SIZE_KEEP_POOL	☐			CHAR	20	0
21	NSIZE_KEEP_POOL	☐			DEC	20	0
22	SIZE_OTHERS	☐			CHAR	20	0
23	NSIZE_OTHERS	☐			DEC	20	0
24	DBUFF_LOGREADS	☐			CHAR	20	0
25	NDBUFF_LOGREADS	☐			DEC	20	0
26	DBUFF_PHYSREADS	☐			CHAR	20	0
27	NDBUFF_PHYSREADS	☐			DEC	20	0
28	DBUFF_PHYSWRITES	☐			CHAR	20	0
29	NDBUFF_PHYSWRITES	☐			DEC	20	0
30	DBUFF_PHYSREADD	☐			CHAR	20	0
31	NDBUFF_PHYSREADD	☐			DEC	20	0
32	DBUFF_PHYSREADDL	☐			CHAR	20	0
33	NDBUFF_PHYSREADDL	☐			DEC	20	0
34	DBUFF_BUSYWAITS	☐			CHAR	20	0
35	NDBUFF_BUSYWAITS	☐			DEC	20	0
36	DBUFF_WAITTIME	☐			CHAR	20	0
37	NDBUFF_WAITTIME	☐			DEC	20	0
38	SHPL_SIZE	☐			CHAR	20	0
39	NSHPL_SIZE	☐			DEC	20	0
40	SHPL_CAQUAL	☐			CHAR	20	0
41	NSHPL_CAQUAL	☐			DEC	19	1
42	SHPL_GETRATIO	☐			CHAR	20	0
43	NSHPL_GETRATIO	☐			DEC	19	1
44	SHPL_PINRATIO	☐			CHAR	20	0
45	NSHPL_PINRATIO	☐			DEC	19	1
46	SHPL_RELOADSPINS	☐			CHAR	20	0
47	NSHPL_RELOADSPINS	☐			DEC	16	4
48	LGBF_SIZE	☐			CHAR	20	0
49	NLGBF_SIZE	☐			DEC	20	0
50	LGBF_ENTRIES	☐			CHAR	20	0
51	NLGBF_ENTRIES	☐			DEC	20	0
52	LGBF_ALLORETR	☐			CHAR	20	0
53	NLGBF_ALLORETR	☐			DEC	20	0
54	LGBF_ALLOFRAT	☐			CHAR	20	0
55	NLGBF_ALLOFRAT	☐			DEC	18	2
56	LGBF_REDLGWT	☐			CHAR	20	0
57	NLGBF_REDLGWT	☐			DEC	20	0
58	LGBF_LOGFILES	☐			CHAR	5	0
59	NLGBF_LOGFILES	☐			DEC	20	0
60	LGBF_LOGFUSE	☐			CHAR	5	0
61	NLGBF_LOGFUSE	☐			DEC	20	0
62	CLL_USERCALLS	☐			CHAR	20	0
63	NCLL_USERCALLS	☐			DEC	20	0
64	CLL_USERCOMM	☐			CHAR	20	0
65	NCLL_USERCOMM	☐			DEC	20	0
66	CLL_USERROLLB	☐			CHAR	20	0
67	NCLL_USERROLLB	☐			DEC	20	0
68	CLL_RECURSIVE	☐			CHAR	20	0
69	NCLL_RECURSIVE	☐			DEC	20	0
70	CLL_PARSECNT	☐			CHAR	20	0
71	NCLL_PARSECNT	☐			DEC	20	0
72	CLL_USR_PER_RCCLL	☐			CHAR	20	0
73	NCLL_USR_PER_RCCLL	☐			DEC	19	1
74	CLL_RDS_PER_UCLL	☐			CHAR	20	0
75	NCLL_RDS_PER_UCLL	☐			DEC	19	1
76	TIMS_BUSYWT	☐			CHAR	20	0
77	NTIMS_BUSYWT	☐			DEC	20	0
78	TIMS_CPUTIME	☐			CHAR	20	0
79	NTIMS_CPUTIME	☐			DEC	20	0
80	TIMS_TIM_PER_UCLL	☐			CHAR	20	0
81	NTIMS_TIM_PER_UCLL	☐			DEC	18	2
82	TIMS_SESS_BUSY	☐			CHAR	20	0
83	NTIMS_SESS_BUSY	☐			DEC	18	2
84	TIMS_CPUUSAGE	☐			CHAR	20	0
85	NTIMS_CPUUSAGE	☐			DEC	18	2
86	TIMS_CPUCOUNT	☐			CHAR	20	0
87	NTIMS_CPUCOUNT	☐			DEC	20	0
88	RDLG_WRITES	☐			CHAR	20	0
89	NRDLG_WRITES	☐			DEC	20	0
90	RDLG_OSBLCKWRT	☐			CHAR	20	0
91	NRDLG_OSBLCKWRT	☐			DEC	20	0
92	RDLG_LTCHTIM	☐			CHAR	20	0
93	NRDLG_LTCHTIM	☐			DEC	20	0
94	RDLG_WRTTIM	☐			CHAR	20	0
95	NRDLG_WRTTIM	☐			DEC	20	0
96	RDLG_MBWRITTEN	☐			CHAR	20	0
97	NRDLG_MBWRITTEN	☐			DEC	20	0
98	TABSF_SHTABSCAN	☐			CHAR	20	0
99	NTABSF_SHTABSCAN	☐			DEC	20	0
100	TABSF_LGTABSCAN	☐			CHAR	20	0
101	NTABSF_LGTABSCAN	☐			DEC	20	0
102	TABSF_FBYROWID	☐			CHAR	20	0
103	NTABSF_FBYROWID	☐			DEC	20	0
104	TABSF_FBYCONTROW	☐			CHAR	20	0
105	NTABSF_FBYCONTROW	☐			DEC	20	0
106	SORT_MEMORY	☐			CHAR	20	0
107	NSORT_MEMORY	☐			DEC	20	0
108	SORT_DISK	☐			CHAR	20	0
109	NSORT_DISK	☐			DEC	20	0
110	SORT_ROWS	☐			CHAR	20	0
111	NSORT_ROWS	☐			DEC	20	0
112	SORT_WAEXOPT	☐			CHAR	20	0
113	NSORT_WAEXOPT	☐			DEC	20	0
114	SORT_WAEXONEP	☐			CHAR	20	0
115	NSORT_WAEXONEP	☐			DEC	20	0
116	SORT_WAEXMULTP	☐			CHAR	20	0
117	NSORT_WAEXMULTP	☐			DEC	20	0
118	IEFF_SOFTPARSE	☐			CHAR	20	0
119	NIEFF_SOFTPARSE	☐			DEC	16	4
120	IEFF_INMEM_SORT	☐			CHAR	20	0
121	NIEFF_INMEM_SORT	☐			DEC	16	4
122	IEFF_PARSTOEXEC	☐			CHAR	20	0
123	NIEFF_PARSTOEXEC	☐			DEC	16	4
124	IEFF_PARSCPUTOTOT	☐			CHAR	20	0
125	NIEFF_PARSCPUTOTOT	☐			DEC	16	4
126	IEFF_PTCPU_PTELPS	☐			CHAR	20	0
127	NIEFF_PTCPU_PTELPS	☐			DEC	16	4
128	NTOTGETS	☐			DEC	20	0
129	NTOTGETMISS	☐			DEC	20	0
130	NGETHITS	☐			DEC	20	0
131	NPINHITS	☐			DEC	20	0
132	NGETS	☐			DEC	20	0
133	NPINS	☐			DEC	20	0
134	NRELOADS	☐			DEC	20	0
135	NLOGICALIO	☐			DEC	20	0
136	NPARSECOUNTHARD	☐			DEC	20	0
137	NPARSECOUNTTOTAL	☐			DEC	20	0
138	NSORTSMEMORY	☐			DEC	20	0
139	NSORTSDISK	☐			DEC	20	0
140	NEXECUTECOUNT	☐			DEC	20	0
141	NPARSETIMECPU	☐			DEC	20	0
142	NCPUSESSION	☐			DEC	20	0
143	NPARSETIMEELAPSED	☐			DEC	20	0
144	NELAPSETIMESEC	☐			DEC	20	0
145	NTOTALWAITTIME	☐			DEC	20	0
146	NDB_CACHE_SIZE	☐			DEC	20	0
147	NDBBUFSIZE_DBCACHE0	☐			DEC	20	0
148	NDBBUFSIZE_DEFPOOL0	☐			DEC	20	0
149	NMEMORY_TARGET	☐			DEC	20	0

History

Last changed by/on	SAP	20110908
SAP Release Created in