| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Enqueue types
As was pointed out to me a few weeks ago, this info is in Oracle8 Reference Release 8.0 A58242-01
TX, Transaction
Not sure about the others. They are not in my manual (8.0.x)
John
-----Original Message-----
Sent: Thursday, February 08, 2001 11:36 PM
To: Multiple recipients of list ORACLE-L
Does anyone recognize enqueues JI, TC, and TX? (Steve, are you on?)
SELECT *
FROM x$ksqst
WHERE ksqstget > 0;
EVENT TOTAL_WAITSTOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
---------------------------------------------------------------- ----------- -------------- ----------- ------------ enqueue 14437878718 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: jfedock_at_ixl.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 Tue Feb 13 2001 - 11:16:42 CST
 |
 |