Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql id with different paln hash value

user3266490Jun 15 2013 — edited Jun 16 2013

Hi,

We using oracle 11.2 on Aix and using OEM.

When checking sql id has only one plan hash value(2558271294) in OEM.

But when checking AWR tables,it shows three plans.Even i checked historical data in OEM.all are pointed to same value.

{code}

QL> select SQL_ID,PLAN_HASH_VALUE,TIMESTAMP,REMARKS,time from dba_hist_sql_plan where SQL_ID='1b9vvcrkk7dsr' order by TIMESTAMP;

SQL_ID PLAN_HASH_VALUE TIMESTAMP REMARKS TIME

------------- --------------- ---------------- ---------- ----------

1b9vvcrkk7dsr 2558271294 2013-02-27-23:47 1

1b9vvcrkk7dsr 2558271294 2013-02-27-23:47

1b9vvcrkk7dsr 2558271294 2013-02-27-23:47 1

1b9vvcrkk7dsr 2558271294 2013-02-27-23:47

1b9vvcrkk7dsr 2558271294 2013-02-27-23:47 1

1b9vvcrkk7dsr 1632776555 2013-02-27-23:47 1

1b9vvcrkk7dsr 1632776555 2013-02-27-23:47

SQL_ID PLAN_HASH_VALUE TIMESTAMP REMARKS TIME

------------- --------------- ---------------- ---------- ----------

1b9vvcrkk7dsr 1632776555 2013-02-27-23:47 1

1b9vvcrkk7dsr 3811220866 2013-06-10-16:38

1b9vvcrkk7dsr 3811220866 2013-06-10-16:38 1

1b9vvcrkk7dsr 3811220866 2013-06-10-16:38

1b9vvcrkk7dsr 3811220866 2013-06-10-16:38 1

19 rows selected.

{code}

Thanks & Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2013

Added on Jun 15 2013

#general-database-discussions

3 comments

10,379 views