Re: stats$filestatxs - a query showing IO stats (without div by zero trap)

No I didn't, that would bugger up the results as you say :-(

So the scrips not so generic, but still useful if you suspect you're suffering from intermittent slow IO.... or persistently slow IO.

I'll bear in mind database bounces for version 3 :-)

Cheers
Tony

On 9/24/07, John Kanagaraj <john.kanagaraj_at_gmail.com> wrote:
> Tony,
>
> Have you considered the fact that a Database restart in-between two
> snapshots would upset this, as the V$FILESTATS would be reset?
>
> --
> John Kanagaraj <><
> DB Soft Inc
> http://www.linkedin.com/in/johnkanagaraj
> http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
> ** The opinions and facts contained in this message are entirely mine and do
> not reflect those of my employer or customers **
> On 9/19/07, Tony Adolph <tony.adolph.dba_at_gmail.com> wrote:
> > Hi all,
> >
>
>
>

--
http://www.freelists.org/webpage/oracle-l