Re: no work - consistent read gets statistic

From: saar <sxmaxoz_at_us.oracle.com>
Date: Fri, 19 Jun 1998 10:19:32 -0700
Message-ID: <358A9DA3.B70AEE7C@us.oracle.com>

> While running my PL/SQL program I see in V$SYSSTAT perf view that the
> statistic "no work - consistent read gets" is near 5000 - 6000.
> It seems that this statistic shows a problem in my PL/SQL code.

problem? why? the name of this statistics is not that great, it's actually a good thing to have,this is the number of times we got a block and had to do NO WORK to get it to the version we like, no block cleanout (ITLs) or rolling back...

Saar.

--

 __  _    _  __    _ _   _   _ ___  ______________________________
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Digital SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Fri Jun 19 1998 - 12:19:32 CDT