SAP ABAP Table HDB_M_SQL_PLAN_CACHE (sys.m_sql_plan_cache)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ HAN-DB (Application Component) SAP HANA Database
     ⤷ SDBA_HDB (Package) DBACOCKPIT for NewDB (HDB)

Basic Data

Table Category	INTTAB	Structure
Structure	HDB_M_SQL_PLAN_CACHE	Table Relationship Diagram
Short Description	sys.m_sql_plan_cache

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	HOST	☐	HDB_HOST	HDB_HOST	CHAR	64	0	Name of database host
2	PORT	☐			INT4	10	0
3	PLAN_ID	☐			DEC	20	0
4	STATEMENT_STRING	☐			STRG	0	0
5	USER_NAME	☐			STRG	0	0
6	SCHEMA_NAME	☐	HDB_SCHEMA_NAME	HDB_SCHEMA_NAME	CHAR	256	0	Schema Name
7	IS_VALID	☐	SAP_BOOL	SAP_BOOL	CHAR	1	0	Boolean Variable (X=True, Space=False)
8	IS_INTERNAL	☐	SAP_BOOL	SAP_BOOL	CHAR	1	0	Boolean Variable (X=True, Space=False)
9	IS_DISTRIBUTED_EXECUTION	☐	SAP_BOOL	SAP_BOOL	CHAR	1	0	Boolean Variable (X=True, Space=False)
10	IS_STORED_PLAN	☐	SAP_BOOL	SAP_BOOL	CHAR	1	0	Boolean Variable (X=True, Space=False)
11	ABAP_VARCHAR_MODE	☐	SAP_BOOL	SAP_BOOL	CHAR	1	0	Boolean Variable (X=True, Space=False)
12	PLAN_MEMORY_SIZE	☐			DEC	20	0
13	REFERENCE_COUNT	☐			DEC	20	0
14	PARAMETER_COUNT	☐			DEC	20	0
15	UPDATED_TABLE_OID	☐			DEC	20	0
16	ACCESSED_TABLES	☐			STRG	0	0
17	ACCESSED_TABLE_NAMES	☐			STRG	0	0
18	ACCESSED_OBJECTS	☐			STRG	0	0
19	ACCESSED_OBJECT_NAMES	☐			STRG	0	0
20	TABLE_LOCATIONS	☐			STRG	0	0
21	STORAGE_TYPE	☐			STRG	0	0
22	PLAN_SHARING_TYPE	☐			STRG	0	0
23	OWNER_CONNECTION_ID	☐			DEC	20	0
24	EXECUTION_COUNT	☐			DEC	20	0
25	TOTAL_EXECUTION_TIME	☐			DEC	20	0
26	AVG_EXECUTION_TIME	☐			DEC	20	0
27	MIN_EXECUTION_TIME	☐			DEC	20	0
28	MAX_EXECUTION_TIME	☐			DEC	20	0
29	STDDEV_EXECUTION_TIME	☐			DEC	20	0
30	TOTAL_CURSOR_DURATION	☐			DEC	20	0
31	AVG_CURSOR_DURATION	☐			DEC	20	0
32	MIN_CURSOR_DURATION	☐			DEC	20	0
33	MAX_CURSOR_DURATION	☐			DEC	20	0
34	STDDEV_CURSOR_DURATION	☐			DEC	20	0
35	TOTAL_EXECUTION_OPEN_TIME	☐			DEC	20	0
36	AVG_EXECUTION_OPEN_TIME	☐			DEC	20	0
37	MIN_EXECUTION_OPEN_TIME	☐			DEC	20	0
38	MAX_EXECUTION_OPEN_TIME	☐			DEC	20	0
39	STDDEV_EXECUTION_OPEN_TIME	☐			DEC	20	0
40	TOTAL_EXECUTION_FETCH_TIME	☐			DEC	20	0
41	AVG_EXECUTION_FETCH_TIME	☐			DEC	20	0
42	MIN_EXECUTION_FETCH_TIME	☐			DEC	20	0
43	MAX_EXECUTION_FETCH_TIME	☐			DEC	20	0
44	STDDEV_EXECUTION_FETCH_TIME	☐			DEC	20	0
45	TOTAL_EXECUTION_CLOSE_TIME	☐			DEC	20	0
46	AVG_EXECUTION_CLOSE_TIME	☐			DEC	20	0
47	MIN_EXECUTION_CLOSE_TIME	☐			DEC	20	0
48	MAX_EXECUTION_CLOSE_TIME	☐			DEC	20	0
49	STDDEV_EXECUTION_CLOSE_TIME	☐			DEC	20	0
50	TOTAL_RESULT_RECORD_COUNT	☐			DEC	20	0
51	LAST_EXECUTION_TIMESTAMP	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
52	TOTAL_LOCK_WAIT_COUNT	☐			DEC	20	0
53	TOTAL_LOCK_WAIT_DURATION	☐			DEC	20	0
54	LAST_PREPARATION_TIMESTAMP	☐	HDB_TSTMP	HDB_TSTMP	CHAR	19	0	Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
55	PREPARATION_COUNT	☐			DEC	20	0
56	TOTAL_PREPARATION_TIME	☐			DEC	20	0
57	AVG_PREPARATION_TIME	☐			DEC	20	0
58	MIN_PREPARATION_TIME	☐			DEC	20	0
59	MAX_PREPARATION_TIME	☐			DEC	20	0
60	STDDEV_PREPARATION_TIME	☐			DEC	20	0
61	STATEMENT_STRING_	☐			STRG	0	0
62	APPLICATION_SOURCE	☐			STRG	0	0

History

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