| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shared memory issues in 9.2.0.3
Yes. Check your limit settings. On 4.3 we were running with defaults and no
issues, then we upgraded to 5L and had to set the limits since the defaults
were too low.
Mark...
-----Original Message-----
Sai Selvaganesan
Sent: Saturday, June 07, 2003 9:39 PM
To: Multiple recipients of list ORACLE-L
mark
very interesting.can you explain. is the ulimit which
we are talking here or something very different from
this
sai
--- Mark Brooks <[EMAIL PROTECTED]> wrote:
> Check the setting for per process memory limits at
> the AIX level. In 4.3
> there is a bug that allowed processes to exceed
> there memory allocations.
> The bug is fixed in 5L so the per process memory
> limits are now enforced. We
> ran into this on our first upgrade to 5L and the
> symptom was 4031 errors
> from processes that ran just fine on 4.3.
>
> Mark...
>
> -----Original Message-----
> Sai Selvaganesan
> Sent: Saturday, June 07, 2003 11:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> hi
> we have upgraded a database from 8.1.7.4 on aix 4.3
> to
> 9.2.0.3 on 5l and was running fine for the past two
> weeks.
> it all started day-before-yesterday when job queue
> coordinator started thrwoing 4031 errora and dbwr
> crashed eventually. we increased the shared pool and
> again the crash happened the next day.
>
> in 8i the shared memory was 120M and i had a shared
> memory of 200Mb initally in 9i (dont know why??)
> ,later increased to 300mb after the first crash,then
> to 650mb after the second crash(oracle's
> suggestion).oracle send me some events to be set in
> init.ota for 4031 errors and the trace that
> generated
> it seems has very little info to debug..not
> surprised..job queue coordinator,apparently wakes up
> every 5 seconds and there is some bug filed
> regarding
> excessive usage of sga by job queue coordinator.
> oracle suggested about the _job_queue_interval
> parameter and i went ahead and put that in setting
> it
> to the same value as in 8i. oracle sent me a script
> which added sharable_mem from v$db_objcect_cache and
> v$sqlarea and told me that i have to double the
> shared
> memeory. i dont hv a clue though i think this is not
> a
> right way to check the shared pool size. also the
> application is the same.nothing has changed and the
> number of processes in the database at any point of
> time is less than 50!!! does 9i require 5 times the
> size of share pool of 8i ????
> has anyone faced this kind of issue? i have been
> sitting in front of the system for the past two days
> trying to figure out what is happening? cant
> question
> oracle..but why really mess around with job queue
> processes when that simple daemon has been working
> fine in all versions?
>
> anycase,gurus please help me out on this.
>
> thanks
> sai
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Sai Selvaganesan
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Brooks 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).Received on Mon Jun 09 2003 - 02:03:52 CDT
 |
 |