Re: "control file sequential read" wait during RAC Benchmark ?
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Feb 2007 23:00:31 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
