Re: ksqsttyp in x$ksqst

From: claudio cutelli <c_cutelli_at_hotmail.com>
Date: Fri, 31 Aug 2001 02:58:02 -0700
Message-ID: <F001.0037E9AB.20010831004603@fatcity.com>

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;

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Yttri, Lisa

  To: <A href="mailto:ORACLE-L_at_fatcity.com"   title=ORACLE-L_at_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 Received on Fri Aug 31 2001 - 04:58:02 CDT