Home » RDBMS Server » Performance Tuning » how to handle this wait event: "control file sequential read"?
how to handle this wait event: "control file sequential read"? [message #210000] Mon, 18 December 2006 21:06 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member


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

Give me some directions.
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 Go to previous message
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:
  


Current Time: Fri Dec 09 02:04:07 CST 2016

Total time taken to generate the page: 0.13686 seconds