RE: ownwers,waiters and converters queues

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 13 Oct 2000 08:55:02 +1000
Message-Id: <10647.119116@fatcity.com>

Hi Danishment,

You can see these queues with an enqueues dump at level 3. The syntax is

alter session set events 'immediate trace name enqueues level 3';

Level 1 just dumps the enqueue hash table; level 2 includes the resources; and level 3 includes the locks and thus shows the queues. The lengths of the queues are a function of the locking activity against the resources. The only instance wide limits apply to the number of resources and locks in the respective fixed arrays. These are set by the 'enqueue_resources' and '_enqueue_locks' parameters respectively. Check the MAX_UTILIZATION and LIMIT_VALUE in V$RESOURCE_LIMIT to see if you are in danger of hitting either limit.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Danisment UNAL [mailto:danisment_at_yahoo.com] Sent: Thursday, 12 October 2000 21:51
To: Multiple recipients of list ORACLE-L Subject: ownwers,waiters and converters queues

Hi,

Note:102925.1 says:

When access is required by a session, a lock structure is obtained and a request is made to acquire access to the resource at a specific level (mode) is made. The lock structure is placed on one of three linked lists which hang off of the resource, called the OWNER (if the enqueue could be acquired), WAITER (if the session is waiting to acquiring the enqueue) and CONVERTER (the session is holding the enqueue in one level but wants to convert it to another) lists.

How can I see OWNER, WAITER and CONVERTER queue. and which parameters determine the length of these parameters.

regards..

---

---

Danisment Gazi Unal
Web: http://www.geocities.com/danisment

---

---

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment UNAL
  INET: danisment_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 Oct 12 2000 - 17:55:02 CDT