Home » RDBMS Server » Performance Tuning » control file sequential read - what is it?
control file sequential read - what is it? [message #65330] Sun, 08 August 2004 19:07 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Everyone,

 

Can someone please explain to me what this wait event means.

 

Many Thanks

IA
Re: control file sequential read - what is it? [message #65331 is a reply to message #65330] Mon, 09 August 2004 05:10 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
This is documented in the Oracle Reference Guide:

"control file sequential read

Reading from the control file. This happens in many cases. For example, while:
  • Making a backup of the controlfiles
  • Sharing information (between instances) from the controlfile
  • Reading other blocks from the controlfiles
  • Reading the header block"


Best regards.

Frank
Re: control file sequential read - what is it? [message #65334 is a reply to message #65331] Mon, 09 August 2004 16:56 Go to previous messageGo to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Frank,

Thanks for the reply.

Can this Wait Event cause a performance bottle neck?

IA
Re: control file sequential read - what is it? [message #65335 is a reply to message #65334] Tue, 10 August 2004 21:55 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

I'm sure it is possible, but quite unlikely. Do a
select from "v$system_event" to get the "total waits"
and "wait time" for this event on your instance. You
can also check if any particular user is waiting on
this event by querying "v$session_event".

Best regards.

Frank
Re: control file sequential read - what is it? [message #65347 is a reply to message #65335] Fri, 13 August 2004 04:16 Go to previous message
IA
Messages: 91
Registered: March 2004
Member
Thanks Frank.
Previous Topic: explain plan
Next Topic: SQL Trace on Parallel Session - Help Please?
Goto Forum:
  


Current Time: Thu Mar 28 14:38:34 CDT 2024