SAP PLAN_HASH_VALUE field - Numerical representation of the SQL plan for the cursor. details in SAP


SAP PLAN_HASH_VALUE field summary

Object Name: PLAN_HASH_VALUE
Dictionary Type:
Description: Numerical representation of the SQL plan for the cursor.


SAP field PLAN_HASH_VALUE is available in the following tables

Details
GVD_SQL-PLAN_HASH_VALUE table field - Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan

Description: Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan
Field Name: PLAN_HASH_VALUE
Data Element: ORA_PLAN_HASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP GVD_SQL table

GORAV_SQL-PLAN_HASH_VALUE table field - Hash Value of Statement (DEC22)

Description: Hash Value of Statement (DEC22)
Field Name: PLAN_HASH_VALUE
Data Element: ORAHASHVALN
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORANUMD22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP GORAV_SQL table

ORAEXPLPAR-PLAN_HASH_VALUE table field -

Description:
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORAEXPLPAR table

GORADBAHIST-PLAN_HASH_VALUE table field - Numerical Representation of the SQL Plan for This Cursor

Description: Numerical Representation of the SQL Plan for This Cursor
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type: DEC
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP GORADBAHIST table

GORASQLAREA-PLAN_HASH_VALUE table field - Plan Hash Value

Description: Plan Hash Value
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP GORASQLAREA table

ORA_S_GV_SQL-PLAN_HASH_VALUE table field - Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan

Description: Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan
Field Name: PLAN_HASH_VALUE
Data Element: ORA_PLAN_HASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORA_S_GV_SQL table

ORA_S_SQL_INFO-PLAN_HASH_VALUE table field - Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan

Description: Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan
Field Name: PLAN_HASH_VALUE
Data Element: ORA_PLAN_HASH_VALUE
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORA_NUMBER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP ORA_S_SQL_INFO table

/SDF/NEWSTMTDATA-PLAN_HASH_VALUE table field - Numerical Representation of the SQL Plan for This Cursor

Description: Numerical Representation of the SQL Plan for This Cursor
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type: DEC
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP /SDF/NEWSTMTDATA table

/SDF/NEWVSQLAREA-PLAN_HASH_VALUE table field - Numerical Representation of the SQL Plan for This Cursor

Description: Numerical Representation of the SQL Plan for This Cursor
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type: DEC
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP /SDF/NEWVSQLAREA table

GORAV_SQL_SELECT-PLAN_HASH_VALUE table field - Hash Value of Statement (DEC22)

Description: Hash Value of Statement (DEC22)
Field Name: PLAN_HASH_VALUE
Data Element: ORAHASHVALN
Data Type: DEC
length (Dec): 22(0)
Check table:
Conversion Routine:
Domain Name: ORANUMD22
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP GORAV_SQL_SELECT table

/SDF/DBAH_SQL_PLAN-PLAN_HASH_VALUE table field - Numerical representation of the SQL plan for the cursor.

Description: Numerical representation of the SQL plan for the cursor.
Field Name: PLAN_HASH_VALUE
Data Element:
Data Type: DEC
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See details of SAP /SDF/DBAH_SQL_PLAN table


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table