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

12seconds CPU time [of which 5seconds went to statspack.snap()] and 7 seconds "control file sequential read" are not significant fractions of the elapsed time of 7minutes. [your server has 8 CPUs on this node so the total available CPU time was 56minutes
and only 12seconds were consumed by Oracle processes ?] Your server and database were actually idle. Get some real load on the system and re-run StatsPack.

Hemant

At 11:12 PM Tuesday, VIVEK_SHARMA wrote:
>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***

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