Bryan, There have been issues with this hanging
problem with OPS in some releases. I am not sure if
this is the problem, but applications that heavily use
the rowcache in an OPS environment can have
performance problems if the shared_pool is loaded and
cause sudden hangs when the row cache object is being
flushed from the shared pool. This problems should
have been fixed with 8171 but it appears that the fix
is in 8173.
Hope this helps,
Scott
- "Rodrigues, Bryan" <BRodrigues_at_elcom.com> wrote:
> No messages in the alert log about dynamic lock
> allocation, the node that is
> having the issue has a small load on it right now
> and the memory is still
> being used up.
>
> Thanks
>
> -----Original Message-----
> Sent: Thursday, May 02, 2002 3:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Any messages in the alert file, like dynamic lock
> allocation or resource
> allocation ?
> In Oracle8 locks and resources for OPS are
> dynamically allocated from the
> shared pool after the initial values of _LM* are
> used.
> You can monitor that in v$resource_limit.
>
> Anjo.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 02, 2002 9:03 PM
>
>
> > Hello,
> > We are working on (2) HP 9000 64 bit HP-UX 11.0 in
> an OPS cluster (non
> mts)
> > on version 8.1.7.2.1 32 bit, we were encountering
> ora-4031 errors on one
> of
> > the instances, so we increased the amount of
> shared pool memory from 100mb
> > to 200mb on both nodes in the cluster. Since the
> shared pool memory was
> > increased the instance on the node that had the
> error is no longer
> > encountering it. But now the instance on the other
> node that was not
> having
> > any issue, is able to keep only 1% of the shared
> pool memory free and has
> > hung 2 times. We are working with Oracle, but
> would appreciate any ideas.
> We
> > know that we have 'bind variable' issues, but not
> enough to get us into
> the
> > situation that we now face.
> >
> >
> > Thank you,
> >
> > Paul Sherman
> > DBA Elcom, Inc.
> > voice - 781-501-4143 (direct #)
> > fax - 781-278-8341 (secure)
> > email - psherman_at_elcom.com
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Sherman, Paul R.
> > INET: PSherman_at_elcom.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).
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rodrigues, Bryan
> INET: BRodrigues_at_elcom.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).
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott
INET: oraracdba_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 Thu May 02 2002 - 17:34:44 CDT