Wednesday, 28 December 2022

How to find the multiple plan hash value for particular sql_id

 select 

  SQL_ID 

, PLAN_HASH_VALUE 

, sum(EXECUTIONS_DELTA) EXECUTIONS

, sum(ROWS_PROCESSED_DELTA) CROWS

, trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS

, trunc(sum(ELAPSED_TIME_DELTA)/1000000/60)  ELA_MINS

from DBA_HIST_SQLSTAT 

where SQL_ID in (

'&sqlid') 

group by SQL_ID , PLAN_HASH_VALUE

order by SQL_ID, CPU_MINS;

No comments:

Post a Comment