fic interest.
> Your query looks very good, I like it. Who is Steve that you have
> mentioned in your post?
>
> > -Original Message-
> > From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 26, 2002 4:12 PM
> > To: Multiple reci
t you have
mentioned in your post?
> -Original Message-
> From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 4:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Control File locks
>
>
> Last year when I worked at a internet
2 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Control File locks
>
>
> Last year when I worked at a internet company. We had same problem.
> CF
> constantly get locked. Steve asked me to run this query. I am not sure
> it
> will help you or not? But at leas
Thanks, Anjo!
-Original Message-From: Anjo Kolk
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 26, 2002 3:35
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Control File locksThere are two locks: a read lock and a
write lock. So most of the times when you read th
--Original Message-From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 26, 2002
3:18 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Control File locks
This
is from Oracle Metal Link.
The
CF locks are used to serialize controlfile transactions and read
Last year when I worked at a internet company. We had same problem.
CF
constantly get locked. Steve asked me to run this query. I am not sure
it
will help you or not? But at least it give you some idea which sql
caused the lock. It was a mystery for us, never get solved. By the way,
do you have st
There are two locks: a read lock and a write lock. So most of the times
when you read the Controlfile you will get the CF enqueue in mode 4. If
you update the control file, you get it in mode 6.
Now the reasons why could be plenty but most likely to
identifying or re-identifying database files
An
. - beginning a hot backup, held exclusive.
- ending a hot backup, held exclusive.
Hope
it clarifies.
Yuval.
-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 26, 2002 3:03
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Control File
Here
is what Ixora has to say on Controlfile waits:
Wait event: refresh
controlfile command The
refresh controlfile command wait event is not important for tuning, but
can be helpful in problem diagnosis. It occurs when mounting a database, and
when a controlfile transaction changes the ra
