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" <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
