RE: TU Enqueue types

From: <Riyaj_Shamsudeen_at_i2.com>
Date: Fri, 09 Feb 2001 13:21:47 -0800
Message-ID: <F001.002B0CFC.20010209131740@fatcity.com>

>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 the

other
2...

                     --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

>

>          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
>

--
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 - 15:21:47 CST