FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Steve Adams discusses enqueue_resources in some detail in his Oracle 8I
internal services book. A brief subset of what he says is as follows
There is no substance to increasing enqueue_resources to combat
enqueue_waits. Oracle returns a ORA-52 or ORA-53 error if it fails to find a
free slot in the enqueue resources or locks fixed arrays. If you are not
seeing that error message then there is no need to increase
enqueue_resources.
Look at v$resource_limits and adjust enqueue_resources and enqueue_locks
parameters to be > 20% above max utilisation recorded.
Look at the dynamic table X$KSQST to find the type of resource that is being
waited for
Finally the enqueue_timeout statistic is misleading as it does not show
timeouts but rather the number of enqueue requests that have been aborted.
This may be because of timeouts but it may also be because a lock is held on
the rows and the code specifies no wait therefore the call is aborted.
I hope I have summarised what Steve says correctly and it helps
Regards
John
-----Original Message-----
From: Nicoll, Iain (Calanais)
[mailto:[EMAIL PROTECTED]]
Sent: 20 April 2001 12:40
To: Multiple recipients of list ORACLE-L
Subject: Enqueue timeouts
Can anyone offer advice on what the problem may be with the
following from
v$sysstat on one of our databases.
NAME VALUE
-------------------------- ---------
enqueue timeouts 17499101
enqueue waits 446362
enqueue deadlocks 2
enqueue requests 47731729
enqueue conversions 1228500
enqueue releases 30232445
Enqueue_resources is set at 5000, DML_Locks is at 4000 and
sessions at 412
so enqueue_resources looks high already but I came across a
note which
suggested increasing enqueue_resources where timeouts were
occurring.
Would anything else be causing this or is there a way to
calculate what
enqueue_resource should be set at.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nicoll, Iain (Calanais)
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).
This e-mail and any files transmitted with it, are confidential to Logica and are
intended solely for the use of the individual or entity to whom they are addressed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hallas, John
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).
