【ORA-01502】unavailable 'SYS.WRH$_SQL_PLAN_PK'
Hello.
I'm facing this problem.
and I can't find solution for this problem.
Please let me know how to fix this problem.
*** KEWROCISTMTEXEC - encountered error: (ORA-01502: 索引'SYS.WRH$_SQL_PLAN_PK'またはそのパーティションが使用不可の状態です。
)
*** SQLSTR: total-len=375, dump-len=240,
STR={SELECT snap_id , SQL_ID, PLAN_HASH_VALUE FROM (SELECT /*+ ordered use_nl(t2) index(t2) */ t2.snap_id , t1.SQLID_KEWRSPE SQL_ID, t1.PLANHASH_KEWRSPE PLAN_HASH_VALUE FROM X$KEWRTSQLPLAN t1, WRH$_SQL_PLAN t2 WHERE t2.dbid(+) = :dbid }
*** KEWRAFM1: Error=13509 encountered by kewrfteh
Sincerely.
0