Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: TU Enqueue types

RE: TU Enqueue types

From: Hagedorn, Linda <lindah_at_epocrates.com>
Date: Fri, 09 Feb 2001 19:21:39 -0800
Message-ID: <F001.002B0EEB.20010209183525@fatcity.com>

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 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 - 21:21:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US