RE: "control file sequential read" wait during RAC Benchmark ?
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "Hemant K Chitale" <hkchital@xxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Feb 2007 20:42:49 +0530
Thanks Hemant
Replies embedded below , Prefixed by -> & in Violet.
Sending you the respective Statspack in an Offline e-mail too.
Cheers
-----Original Message-----
From: Hemant K Chitale [mailto:hkchital@xxxxxxxxxxxxxx]
Sent: Tuesday, February 27, 2007 8:31 PM
To: VIVEK_SHARMA; oracle-l@xxxxxxxxxxxxx
Subject: Re: "control file sequential read" wait during RAC Benchmark ?
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 ?
-> Period between the Statspack Snapshots = 6.97 minutes
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- ---------
-------------------
Begin Snap: 27 23-Feb-07 17:53:38 70 16.1
End Snap: 28 23-Feb-07 18:00:36 80 18.3
Elapsed: 6.97 (mins)
Why do you think "control file sequential read" waits would be tempered
by
"transaction be grouped logically so that transactions hit different
data blocks" ?
-> That is a Question & I do NOT know if "grouping transactions" has any
impact on the "control file sequential read" wait.
-> Seek your Advice on this.
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
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Other related posts:
