Re: ksqsttyp in x$ksqst

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Fri, 31 Aug 2001 00:16:17 -0700
Message-ID: <F001.0037E89E.20010831001035@fatcity.com>

It is a controlfile enqueue. It happens when Oracle writes to the controlfile. If you use RMAN, you could suffer that type of lock. Because of the reusable or dynamic or shared section of the controlfile. However in most of the cases, a CF lock it is not common cause of contention. Therefore, you should not consider them important if you only see them in that table. Because when you issue a query over ksqst, you always see CF and all the types of locks as MR or RT, fe.

Dealing with controlfiles some issues could be consider as important ones. Fe, the multiplexing, as every file of the database: the fs or disk where you put it, the parameter control_file_record_keep_time, if you use RMAN, try with a catalog, and the parameter you use to create the database or the controlfiles as maxloghistory, etc....

Regards.

• "Yttri, Lisa" <lisa.yttri_at_cnh.com> wrote:
  > 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
  >
  

  ---

Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062

---

Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.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 Aug 31 2001 - 02:16:17 CDT