Re: 10053 trace for sql fired from pl/sql (stored code)
- From: Phil Jones <phillipjones@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 22 Dec 2005 23:23:38 +0100
On 22/12/05, Radoulov, Dimitre <cichomitiko@xxxxxxxxx> wrote:
>
> > "the query must be (hard) parsed and it must be parsed by the CBO". Maybe
> the original poster is missing these requirements.
>
> I tried to force the hard parse with lower/upper case and different
> comments.
>
> I suppose I'm missing something, so if anyone else could try :)
alter system flush shared_pool;
is your friend.
Oh, and if you don't know about:
alter system flush buffer_cache;
in 10g, it can be useful in other circumstances.
Cheers, and have a good Christmas all.
---Phil
--
//www.freelists.org/webpage/oracle-l
Other related posts:
