Re: oradebug dump processstate 10

Quoting Egor Starostin <egorst_at_gmail.com>:

> Run1 latches total versus runs -- difference and pct
> Run1 Run2 Diff Pct
> 7,067 2,301,590 2,294,523 .31%
> ***

Are you sure this is a reliable figure? I don't get anywhere NEAR these many.

> To me, v$access is only usable on idle instances.

Not necessarily. v$* views were put there for a reason, if they were soooo bad Oracle wouldn't make them visible in the first place.

Don't forget you are not comparing apples with apples: traces themselves have not been instrumented with waits, you simply do NOT know if your trace isn't causing a lot more overhead in places where waits are not counted!

Let's not stop using the v$* views just because access to them shows up badly in comparison to something that is not even instrumented!  

Cheers
Nuno Souto
from sunny Sydney

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