Paul,
Most of my work is on HP-UX and AIX.
I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I work with
are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either.
- Kirti
- Paul Drake <discgolfdba_at_yahoo.com> wrote:
> --- Kirtikumar Deshpande
> <kirtikumar_deshpande_at_yahoo.com> wrote:
> > I think it depends on your applications.
> >
> > In DSS type environments we are still stuggling to
> > figure out if P_A_T is helping or not. Initial
> > tests are not in P_A_T's favor.
> >
> > But in another Application, that is 80% OLTP, P_A_T
> > was the only choice to avoid swapping. This
> > 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S =
> > 1MB)at the instance level. It has over 600
> > persistent users. No MTS in use.
> >
> > - Kirti
>
> Kirti,
>
> I saw in a 9.2.0.4 database just this evening, much to
> my surprise, an ORA-00600 in the alert log with - you
> guessed it - [723], [10332], [10332], [memory leak].
>
> The database was setup in a less than optimal fashion
> as far as memory allocations go. The initial
> pga_aggregate_target was only 64M (server had 3 GB of
> memory and only one instance up) so I'm calling this
> one a non-sensical configuration error for the moment,
> as there is no need to size a PGA so small. If you're
> running with that small a memory footprint, don't use
> pga_aggregate_target.
>
> After resetting the parameter to 256M and cycling the
> instance, no ORA-00600's were recorded at instance
> shutdown. That was not really a good test though, will
> have to see tomorrow evening after the day's load has
> hit it.
>
> Paul
>
> this was on w2k server sp3, 9.2.0.4 std ed
>
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 22 2004 - 07:14:25 CST