OraFAQ Forum: Performance Tuning » control file sequential read

Home » RDBMS Server » Performance Tuning » control file sequential read - what is it?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

control file sequential read - what is it? [message #65330]

Sun, 08 August 2004 19:07

IA
Messages: 91
Registered: March 2004

Member

Hi Everyone,

�

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

�

Many Thanks

IA

Report message to a moderator

Re: control file sequential read - what is it? [message #65331 is a reply to message #65330]

Mon, 09 August 2004 05:10

Frank Naude
Messages: 4587
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

Report message to a moderator

Re: control file sequential read - what is it? [message #65334 is a reply to message #65331]

Mon, 09 August 2004 16:56

IA
Messages: 91
Registered: March 2004

Member

Hi Frank,

Thanks for the reply.

Can this Wait Event cause a performance bottle neck?

IA

Report message to a moderator

Re: control file sequential read - what is it? [message #65335 is a reply to message #65334]

Tue, 10 August 2004 21:55

Frank Naude
Messages: 4587
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

Report message to a moderator

Re: control file sequential read - what is it? [message #65347 is a reply to message #65335]

Fri, 13 August 2004 04:16

IA
Messages: 91
Registered: March 2004

Member

Thanks Frank.

Report message to a moderator

Previous Topic:	explain plan
Next Topic:	SQL Trace on Parallel Session - Help Please?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 04:31:17 CST 2025