DBA_SQL_PLAN_BASELINES: where to get PLAN_HASH_VALUE from?
Hi all ,
when selecting from DBA_SQL_PLAN_BASELINES several information about the SQL Baseline are provided. But I am missing the column/information PLAN_HASH_VALUE. In OEM this information is provided:
SQL_PLAN_1r33dn4r339br239b7db8
SQL handle: SQL_1b8c6da12e31a577
SQL text: SELECT DISTINCT ...
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_1r33dn4r339br239b7db8 Plan id: 597392824
Enabled: YES Fixed: YES Accepted: YES Origin: MANUAL-LOAD-FROM-CURSOR-CACHE
Plan rows: From dictionary
--------------------------------------------------------------------------------
Plan hash value: 135405036
-------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
--------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 13 (100)| | | | |
So it's my understanding that it must be possible to join DBA_SQL_PLAN_BASELINES with some other view/table which contains the column/information PLAN_HASH_VALUE.