Re: workaround for v$sql

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Fri, 16 Mar 2007 18:10:30 +0100
Message-ID: <4ef2fbf50703161010m46a2b51fmca92efa88a054a83@mail.gmail.com>

On 3/16/07, Ankur Godambe <agodambe_at_ketera.com> wrote:
> changes. I hit this bug#4434689 with 9.2.0.7 where selects on v$sql_plan
> failes with ora-600 [504].

I haven't found the bug on Metalink; if the bug is similar to 2525630, you can avoid the ORA-600 by not selecting access_predicates and filter_predicates. These informations are lost, but at least you have the rest of the plans.

The bug is solved in 10g.

bye
al

-- 
Alberto Dell'Era
"Per aspera ad astra"
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 16 2007 - 12:10:30 CDT

Re: workaround for v$sql_plan