Re: Session Stats

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:bb26h1$39e$1_at_ctb-nnrp2.saix.net...
> How bad is bad when a v$session_stat becomes a very large negative value
> (over a billion) for a v$statname like table scan rows gotten?

The record for me is a query that
would have done 350,000,000,000,000,000
reads (estimated from a subset).

I called it the "legacy query": it would have returned the first row to our grandchildren...

7.3, Sequent. I didn't write it, but I
had to "tune" (ahem:scrap&re-write) it.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam