From c_cutelli@hotmail.com Fri, 31 Aug 2001 02:58:02 -0700
From: "claudio cutelli" <c_cutelli@hotmail.com>
Date: Fri, 31 Aug 2001 02:58:02 -0700
Subject: Re: ksqsttyp in x$ksqst
Message-ID: <F001.0037E9AB.20010831004603@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: ksqsttyp in x$ksqst



Hi, CF is Control file 
 
 create view DBA_LOCK as
  select 
        sid session_id,
        decode(type, 
                'MR', 'Media Recovery', 
                'RT', 'Redo Thread',
                'UN', 'User Name',
                'TX', 'Transaction',
                'TM', 'DML',
                'UL', 'PL/SQL User Lock',
                'DX', 'Distributed Xaction',
                'CF', 'Control File',
                'IS', 'Instance State',
                'FS', 'File Set',
                'IR', 'Instance Recovery',
                'ST', 'Disk Space Transaction',
                'TS', 'Temp Segment',
                'IV', 'Library Cache Invalidation',
                'LS', 'Log Start or Switch',
                'RW', 'Row Wait',
                'SQ', 'Sequence Number',
                'TE', 'Extend Table',
                'TT', 'Temp Table',
                type) lock_type,
        decode(lmode, 
                0, 'None',           /* Mon Lock equivalent */
                1, 'Null',           /* N */
                2, 'Row-S (SS)',     /* L */
                3, 'Row-X (SX)',     /* R */
                4, 'Share',          /* S */
                5, 'S/Row-X (SSX)',  /* C */
                6, 'Exclusive',      /* X */
                to_char(lmode)) mode_held,
         decode(request,
                0, 'None',           /* Mon Lock equivalent */
                1, 'Null',           /* N */
                2, 'Row-S (SS)',     /* L */
                3, 'Row-X (SX)',     /* R */
                4, 'Share',          /* S */
                5, 'S/Row-X (SSX)',  /* C */
                6, 'Exclusive',      /* X */
                to_char(request)) mode_requested,
         to_char(id1) lock_id1, to_char(id2) lock_id2,
         ctime last_convert,
         decode(block,
                0, 'Not Blocking',  /* Not blocking any other processes */
                1, 'Blocking',      /* This lock blocks other processes */
                2, 'Global',        /* This lock is global, so we can't tell */
                to_char(block)) blocking_others
      from v$lock;
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Yttri, Lisa 
  
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Thursday, August 30, 2001 9:32 
  PM
  Subject: ksqsttyp in x$ksqst
  
  Hi - 
  Where can I find out what the values mean in the ksqsttyp 
  column on the x$ksqst table?  I am having some waits associated with the 
  value "CF", but I don't know what that means.
  If anyone can help, I'd greatly appreciate it. 
  Lisa