Re: Queries slow after Upgrade to Oracle 9i

From: Snewber <s_at_s.com>
Date: Thu, 11 Nov 2004 10:56:50 +1000
Message-ID: <cmudck$cla$1@bunyip.cc.uq.edu.au>

You only upgraded to 9.2.0.5, what about 9.2.0.6 :)

I normally set my parameters as follows:

PGA_AGGREGATE_TARGET = 50 M It makes it a lot easier to read and thus prevents mistakes such as having an extra digit which may cause you to allocate 524288000 instead of 50 M.

"DB Dude" <DBdude_From_NY_at_yahoo.com> wrote in message news:f65280c4.0411100827.72f08b93_at_posting.google.com...
> init para
> PGA_AGGREGATE_TARGET = 52428800
>
> Advice from v$PGA_TARGET_ADVIDE
> pga_target_for_estimate = 419430400
>
> Advice from V$PGASTAT
> Total PGA Allocated = 283429888
Received on Wed Nov 10 2004 - 18:56:50 CST