Re: This small query kills oracle 9.2.0.3 (nightmare)

"Andras Kovacs" <andkovacs_at_yahoo.com> wrote in message news:412ebb69.0309081450.39d995f3_at_posting.google.com...

> Finally we managed to isolate the problem.
> The problem is with sort_area_size and sort_area_retained_size.
> They are large 80M and 40M. Some queries retrieve 500M data.
> At Oracle nobody paid attention to them until this morning.
> On Oracle 9 these parameters (on our system) don't work very well.
> We had to set pga_aggregate_target instead. I read an Oracle note
> saying that parameters like "_area_size" should not be used from
> version 9.

That's baaaad news in a way... Imagine someone just plonking their 9i on top of 8 and not going through the motions of getting rid of any superfluous parameters! I'm reminded of quite a few 3rd-party apps that turn on the weirdest stuff in init.ora!

All care is needed. Not a good idea, these major "changes" in parameter requirements. If they are not really needed, then it's much better to just "disable" them. Rather than having them mess up perfectly working systems.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam