Re: Enqueue types

From: yong huang <yong321_at_yahoo.com>
Date: Thu, 22 Feb 2001 00:41:41 -0800
Message-ID: <F001.002BA182.20010221151528@fatcity.com>

Hi, Linda,

You posted the following message 2 weeks ago. I didn't see an answer about the lock types JI and TC (TX is for transaction). Today I'm reading Anjo Kolk's paper again on wait events. He said there was a bug in 7.0 and 7.1 that "could cause the lock name to be corrupted. So if a weird name shows up, you are mostly likely running in[to] this bug". I wonder what version of Oracle you're using. If your version is not that old, hopefully we can explain what you see by the fact that Oracle fixed that bug but introduced new ones that corrupt lock names.

If anyone knows a new version of Anjo Kolk's paper, please let us know. The one I'm reading is from www.evdbt.com/event.pdf.

Yong Huang
yong321_at_yahoo.com

you wrote:

Does anyone recognize enqueues JI, TC, and TX? (Steve, are you on?)

SELECT *
FROM x$ksqst
WHERE ksqstget > 0;

EVENT        TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
------------ ----------- --------       ----------  ------------
enqueue      144378      78718          25112607    173.936521


ADDR                   INDX    INST_ID KS   KSQSTGET   KSQSTWAT
---------------- ---------- ---------- -- ---------- ----------
0000000399F11808         69          1 CF     179654         39
0000000399F11820         72          1 CI      65152          0
0000000399F11880         84          1 CU    1043538         55
0000000399F11938        107          1 DL        444          0
0000000399F11968        113          1 DR       5569          0
0000000399F11988        117          1 DV      46432          0
0000000399F11998        119          1 DX      95350          0
0000000399F11B70        178          1 FS          1          0
0000000399F11D90        246          1 HW      98917          0
0000000399F11E70        274          1 IS       9441          0
0000000399F11F20        296          1 JI      14455       5511   <---
0000000399F12268        401          1 MR         20          0
0000000399F12500        484          1 PE     868094          0
0000000399F12508        485          1 PF        134          0
0000000399F12568        497          1 PR         93          0
0000000399F12570        498          1 PS        340          0
0000000399F12778        563          1 RT          1          0
0000000399F12860        592          1 SQ     504008         96
0000000399F12870        594          1 SS          6          0
0000000399F12878        595          1 ST      21481          1
0000000399F128F0        610          1 TC      23860       1243   <-----
0000000399F12940        620          1 TM   17757089          0
0000000399F12970        626          1 TS       3829          0
0000000399F12978        627          1 TT    1352011          0
0000000399F12998        631          1 TX   16390088        648   <----
0000000399F12A70        658          1 US     870014          0
0000000399F12C38        715          1 WL      47348          2

27 rows selected.

Any information or referral to a manual is appreciated. I don't have Steve's book with me, unfortunately.

Thanks,

Linda

Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: yong huang
INET: yong321_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 Feb 22 2001 - 02:41:41 CST