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@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: