OraFAQ Forum: Performance Tuning » how to handle this wait event: "control file sequential read"?

Home » RDBMS Server » Performance Tuning » how to handle this wait event: "control file sequential read"?

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

how to handle this wait event: "control file sequential read"? [message #210000]

Mon, 18 December 2006 21:06

wxfjordan
Messages: 92
Registered: December 2006

Member

how to handle this wait event: "control file sequential read"?

Give me some directions.

Report message to a moderator

Re: how to handle this wait event: "control file sequential read"? [message #210005 is a reply to message #210000]

Mon, 18 December 2006 22:27

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
control file sequential read
Reading from the controlfile. 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

Wait Time: The wait time is the elapsed time of the read.

Parameters:

file#
The controlfile from which the session is reading.

block#
Block number in the controlfile from where the session starts to read. The block size is the physical block size of the port (usually 512 bytes, some UNIX ports have 1 or 2 Kilobytes).

blocks
The number of blocks that the session is trying to read.

http://www.csee.umbc.edu/help/oracle8/server.815/a67790/apa.htm

also go through below link
http://www.dbazine.com/oracle/or-articles/burleson8

regards
Taj

[Updated on: Mon, 18 December 2006 22:44]

Report message to a moderator

Previous Topic:	Performance tuning
Next Topic:	Help - Performance Issue - statspack report attached

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 22:59:40 CDT 2024