| 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: TU Enqueue types
Thanks Riyaj. I called support and had them look up TC. They're saying they think it has something to do with checkpoints. I've asked them for specifics and will post them when Oracle replies.
Regards, Linda
-----Original Message-----
From: Riyaj_Shamsudeen_at_i2.com [mailto:Riyaj_Shamsudeen_at_i2.com]
Sent: Friday, February 09, 2001 1:18 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: TU Enqueue types
From the metalink...Even the reference guide, does not mention this enqueue.. Document bug.
JI "Enqueue used during AJV
snapshot refresh"
The JI lock was introduced in
Oracle8.1
How Many Resources: One per
snapshot
How Many Locks: One per
snapshot
When & How Used: Used to
serialize snapshot refresh for
a snapshot / mview.
TC seems to be an enqueue related with PQO.
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Scott.Shafer_at_dcpds.cp ms.osd.mil To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent by: cc: root_at_fatcity.com Subject: RE: TU Enqueue types 02/09/01 12:57 PM Please respond to ORACLE-L TX is transaction lock. Can't find any info on theother
--Scott Shafer San Antonio, TX > -----Original Message----- > From: Hagedorn, Linda [SMTP:lindah_at_epocrates.com] > Sent: Thursday, February 08, 2001 10:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Enqueue types
> > > 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 >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Scott.Shafer_at_dcpds.cpms.osd.mil 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Riyaj_Shamsudeen_at_i2.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 Fri Feb 09 2001 - 21:21:39 CST
 |
 |