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 <[EMAIL PROTECTED]> wrote: > --- Kirtikumar Deshpande > <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
