SAP ABAP Table ORAEXPLPAR (Parameter for Explain from v$sql_plan)

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	ORAEXPLPAR	Table Relationship Diagram
Short Description	Parameter for Explain from v$sql_plan

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	ADDRESS	☐	ORAADDRESS	CHAR16	CHAR	16	0	Address of statement in the cache
2	HASH_VALUE	☐	ORAHASHVAL	ORAP16	FLTP	16	16	Hash value of statement
3	CHILD_NUMBER	☐	ORACHILDNUM	ORAP16	FLTP	16	16	Child Cursor Number
4	CON_NAME	☐	DBCON_NAME	DBCON_NAME	CHAR	30	0	Logical name for a database connection	*
5	FLAGS	☐	FIELDNAME	FDNAME	CHAR	30	0	Field Name	*
6	INST_ID	☐	ORAINST_ID	ORANUMBER	INT4	10	0	Oracle Instance ID
7	ASHEVENT	☐			CHAR	64	0
8	ASH_SOURCE	☐			CHAR	30	0
9	SQL_ID	☐			CHAR	13	0
10	HIST_BEGIN_TS	☐	SDBA_BEGIN	SDBA_TSTMP	CHAR	14	0	Start of the DBA action
11	HIST_END_TS	☐	SDBA_BEGIN	SDBA_TSTMP	CHAR	14	0	Start of the DBA action
12	PLAN_HASH_VALUE	☐			CHAR	30	0

History

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