Arn,
You could be running into bug 1397603 that is fixed in
the 8.1.7.2 patchset. The workaround is to set
_db_handles_cached = 0 although if a db already has a
problem with latch contention, this is likely to make
it worse. Bug 1397603 is a generic bug specific to
8.1.7.
The following query can be used to monitor the memory
usage for state objects:
SELECT * FROM V$SGASTAT WHERE NAME LIKE '%tate
object%';
This memory use should level off after the db has been
in use for a few hours. If it's constantly growing
then it's most likely bug 1397603.
There is a similar bug specific to 8.1.6.3, bug
1640583, that doesn't have a workaround. There are
PSE (patchset exceptions) for this bug on most
platforms, however. Contact OSS for the PSE. BTW,
this PSE is mandatory for running apps 11i on 8.1.6.3.
HTH,
- Anita
- Arn Klammer <Arn.Klammer_at_austrac.gov.au> wrote:
> Thanx, everyone, for replying so quickly! We're on
> 8.1.7.1 (sorry for omitting that in my OP). I'll
> look for the patch straight after this.
>
> Rahul and Connor, when you say the cause may be that
> the application is not using bind variables, do you
> mean that the application is using dynamic SQL, and
> thus almost every call to the DB during application
> execution is different, thus limiting query reuse?
> If that's the case, then this is not the cause in
> our app, as we don't use dynamic SQL at all.
> However, if you mean another way of not using bind
> variables, but in static queries, then could you
> please explain how this could be done, so I can
> check our app?
>
> Thanx very much.
>
> -arn
>
> >>> rahul_at_ratelindo.co.id 21/9/2001 23:05:22 >>>
> This message has been scanned by MAILSweeper.
>
>
> i would take a look at the application before
> increasing the size
>
> > ----------
> > From: Mercadante, Thomas
> F[SMTP:NDATFM_at_labor.state.ny.us]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Friday, September 21, 2001 7:50 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Rash of shared memory errors
> >
> > Arn
> >
> > A shared pool size of 16 Meg is not large enough.
> This error clearly
> > indicates that you are out of memory.
> >
> > It may be larger than your test and maintenance
> db, but it is not large
> > enough for your developers.
> >
> > I don't know about you, but I have more developers
> on my Dev instances
> > than
> > testers on my testing instance! My shared pool
> value in my Dev instance
> > is
> > 80Meg, and I never get this error.
> >
> > Try increasing your shared pool to at least 50 Meg
> and see if the problem
> > goes away.
> >
> > Hope this helps
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> >
> > -----Original Message-----
> > Sent: Friday, September 21, 2001 3:55 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> >
> > Just recently, we have been frequently receiving
> errors like the following
> > in our development database:
> >
> > ERROR:
> > ORA-04031: unable to allocate 4096 bytes of shared
> memory ("shared
> > pool","BEGIN
> > DBMS_OUTPUT.DISABLE; E...","PL/SQL
> MPCODE","BAMIMA: Bam Buffer")
> >
> > The size of our shared pool is not too small (I
> think); it's larger than
> > our
> > test and maintenance databases, for example.
> >
> > shared_pool_reserved_size string
> 800000
> > shared_pool_size string
> 16000000
> >
> > What could be causing this level of frequent
> fragmentation? We have been
> > developing a new application in the database, but
> this has been ongoing
> > for
> > some months; the errors appeared only in the last
> week or so.
> >
> > What should I be looking for to solve this?
> >
> > Thanx for any advice.
> >
> > -arn
> >
> >
> >
> >
> >
>
> > This email and any files transmitted with it are
> confidential and
> > intended solely for the use of the individual or
> entity to whom they
> > are addressed. If you have received this email in
> error please notify
> > the system manager.
> >
> > This footnote also confirms that this email
> message has been swept by
> > MIMEsweeper for the presence of computer viruses.
> >
> > www.mimesweeper.com
> >
>
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Arn Klammer
> > INET: Arn.Klammer_at_austrac.gov.au
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > 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).
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Mercadante, Thomas F
> > INET: NDATFM_at_labor.state.ny.us
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > 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).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Arn Klammer
> INET: Arn.Klammer_at_austrac.gov.au
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sun Sep 23 2001 - 22:54:26 CDT
