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

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_at_singnet.com.sg] Sent: Tuesday, February 27, 2007 8:31 PM To: VIVEK_SHARMA; oracle-l_at_freelists.org 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*** -- http://www.freelists.org/webpage/oracle-l