SAP ABAP Table GORADBAHIST (Shared Cursor Cache DBA History)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
     ⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB

Basic Data

Table Category	INTTAB	Structure
Structure	GORADBAHIST	Table Relationship Diagram
Short Description	Shared Cursor Cache DBA History

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	INST_ID	☐			INT4	10	0
2	INST_NAME	☐			CHAR	16	0
3	SQL_ID	☐			CHAR	13	0
4	SQL_TEXT	☐			CHAR	80	0
5	SHAR_MEM	☐			DEC	30	0
6	SQLSORTS	☐			DEC	30	0
7	LOAD_VERSN	☐			DEC	30	0
8	FETCHES	☐			DEC	30	0
9	EXECUTIONS	☐			DEC	30	0
10	END_OF_FETCHES	☐			DEC	30	0
11	LOADS	☐			DEC	30	0
12	INVALIDATN	☐			INT4	10	0
13	PARSE_CALL	☐			INT4	10	0
14	DISK_READS	☐			DEC	30	0
15	BUFFER_GET	☐			DEC	30	0
16	RECS_PROCE	☐			DEC	30	0
17	MODULENAME	☐			CHAR	64	0
18	ACTION	☐			CHAR	64	0
19	DISKRD_EXC	☐			DEC	30	2
20	BUFGET_EXC	☐			DEC	30	2
21	PARCAL_EXC	☐			DEC	30	0
22	RECPRO_EXC	☐			DEC	30	2
23	BUFGET_ROW	☐			DEC	30	2
24	PARSUSERID	☐			INT4	10	0
25	USER_NAME	☐			CHAR	30	0
26	CPU_TIME	☐			DEC	30	0
27	CPU_TIME_PERC	☐			DEC	10	0
28	ELAP_TIME	☐			DEC	30	0
29	ELAP_TIME_PERC	☐			DEC	10	0
30	WAIT_TIME	☐			DEC	30	0
31	CPU_EXC	☐			DEC	30	0
32	ELAP_EXC	☐			DEC	30	0
33	WAIT_EXC	☐			DEC	30	0
34	APPLW_EXEC	☐			DEC	30	0
35	CONCW_EXEC	☐			DEC	30	0
36	CLUSTW_EXEC	☐			DEC	30	0
37	OUTL_CAT	☐			CHAR	110	0
38	OUTL_SID	☐			INT4	10	0
39	LAST_LOAD_TIME	☐			CHAR	19	0
40	LAST_ACTIVE_TIME	☐			CHAR	19	0
41	DIRECT_WRITES	☐			DEC	30	0
42	OBJECT_STATUS	☐			CHAR	19	0
43	APPL_WAIT_TIME	☐			DEC	30	0
44	CONC_WAIT_TIME	☐			DEC	30	0
45	CLUST_WAIT_TIME	☐			DEC	30	0
46	USR_IO_WAIT_TIME	☐			DEC	30	0
47	PLSQL_EXEC_TIME	☐			DEC	30	0
48	USR_IO_PER_EXEC	☐			DEC	30	0
49	PLSQL_PER_EXEC	☐			DEC	30	0
50	SQL_PROFILE	☐			CHAR	64	0
51	PLAN_HASH_VALUE	☐			DEC	30	0
52	OPTIMIZER_MODE	☐			CHAR	10	0
53	PARSING_SCHEMA_NAME	☐			CHAR	30	0
54	SQL_PATCH	☐			CHAR	30	0
55	SQL_PLAN_BASELINE	☐			CHAR	30	0
56	AVG_HARD_PARSE_TIME	☐			DEC	30	0
57	AVG_HARD_PARSE_TIME_EXC	☐			DEC	30	2
58	IO_CEL_OFL_ELIG_BYT	☐			DEC	30	0
59	IO_CEL_OFL_ELIG_BYT_EXC	☐			DEC	30	2
60	IO_INTCON_BYT	☐			DEC	30	0
61	IO_INTCON_BYT_EXC	☐			DEC	30	2
62	PHYS_READ_REQ	☐			DEC	30	0
63	PHYS_READ_REQ_EXC	☐			DEC	30	2
64	PHYS_READ_BYT	☐			DEC	30	0
65	PHYS_READ_BYT_EXC	☐			DEC	30	2
66	PHYS_WRITE_REQ	☐			DEC	30	0
67	PHYS_WRITE_REQ_EXC	☐			DEC	30	2
68	PHYS_WRITE_BYT	☐			DEC	30	0
69	PHYS_WRITE_BYT_EXC	☐			DEC	30	2
70	EXACT_MATCHING_SIG	☐			DEC	30	0
71	FORCE_MATCHING_SIG	☐			DEC	30	0
72	IO_CEL_UNCOMP_BYT	☐			DEC	30	0
73	IO_CEL_UNCOMP_BYT_EXC	☐			DEC	30	2
74	IO_CEL_OFL_RET_BYT	☐			DEC	30	0
75	IO_CEL_OFL_RB_EXC	☐			DEC	30	2
76	OPT_PHYS_READS	☐			DEC	30	0
77	OPT_PHYS_READS_EXC	☐			DEC	30	2

History

Last changed by/on	SAP	20140117
SAP Release Created in	740