Check out the following two values:

Resource     Current          Max            Initial          Limit
Name          Utilization       Utilization    Allocation   Value
----------    ----------       ----------    ----------  --------
lm_ress        252143          256732     177599       UNLIMITED
lm_locks      278106          288642     189208       UNLIMITED

Notice that "Current/Max Utilization" is much higher than "Initial
Allocation"?

This means that (messages to alert.log or not), the DLM is overflowing its
allocated space in the SGA and invading the Shared Pool.  Increase your
LM_RESS and LM_LOCKS parameter values...

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 3:58 PM


> Here is the results from v$resource limit on the node with the problem.
>
> RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION
> INITIAL_AL LIMIT_VALU
> ------------------------------ ------------------- ---------------
> ---------- ----------
> processes                                       52              54
> 800        800
> sessions                                        52              56
> 885        885
> enqueue_locks                                  233             242
> 11081      11081
> enqueue_resources                              233             261
> 7870       7870
> _lm_procs                                       52              53
> 801        801
> lm_ress                                     252143          256732
> 177599  UNLIMITED
> lm_locks                                    278106          288642
> 189208  UNLIMITED
> lm_cache_ress                                25822           25920
> 0  UNLIMITED
> dml_locks                                        0              42
> 7250       7250
> temporary_table_locks                            0               2
> UNLIMITED  UNLIMITED
> transactions                                     0               9
> 973        973
>
> RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION
> INITIAL_AL LIMIT_VALU
> ------------------------------ ------------------- ---------------
> ---------- ----------
> sort_segment_locks                               0               5
> UNLIMITED  UNLIMITED
> max_rollback_segments                            9               9
> 195        195
> distributed_transactions                         0               0
> 5          5
> mts_max_servers                                  0               0
> 20         20
> parallel_max_servers                             1               1
> 6          6
>
> 16 rows selected.
>
> Please disregard previous message with the contents of v$resource table.
>
>
> -----Original Message-----
> Sent: Thursday, May 02, 2002 4:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What does V$RESOURCE_LIMIT say?  You can probably post that as a reply...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, May 02, 2002 2:27 PM
>
>
> > 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" <[EMAIL PROTECTED]>
> > 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 - [EMAIL PROTECTED]
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Sherman, Paul R.
> > >   INET: [EMAIL PROTECTED]
> > >
> > > 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: [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.com
> > --
> > Author: Anjo Kolk
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [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.com
> > --
> > Author: Rodrigues, Bryan
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [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.com
> --
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
>
> 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: [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.com
> --
> Author: Rodrigues, Bryan
>   INET: [EMAIL PROTECTED]
>
> 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: [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.com
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

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: [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).

Reply via email to