Re: "control file sequential read" wait during RAC Benchmark ?

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 27 Feb 2007 23:00:31 +0800
Message-Id: <200702271500.l1RF0cFf007662@smtp18.singnet.com.sg>

Total wait time for "control file sequential read" is 7 seconds. Is that significant ? Was the StatsPack snapshot for a duration of 10 minutes ? 1 hour ?

Why do you think "control file sequential read" waits would be tempered by "transaction be grouped logically so that transactions hit different data blocks" ?

Hemant
At 09:07 PM Tuesday, VIVEK_SHARMA wrote:
>Folks
>
>
>Qs 2) Should Transactions be grouped Logically so that Transactions
>Hit different Data Blocks on the 2 Nodes?
>
>Top 5 Timed
>Events Avg %Total
>~~~~~~~~~~~~~~~~~~
>wait Call
>Event Waits Time
>(s) (ms) Time
>----------------------------------------- ------------ -----------
>------ ------
>CPU
>time 12 43.6
>control file sequential
>read 21,969 7 0 25.4

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 27 2007 - 09:00:31 CST