Re: V$SQLAREA Stats Bug?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 26 Feb 1999 19:16:49 GMT
Message-ID: <36e1f2cc.21955991@192.86.155.100>

A copy of this was sent to "John P. Higgins" <jh33378_at_deere.com> (if that email address didn't require changing) On Fri, 26 Feb 1999 11:29:14 -0600, you wrote:

>The V$SQLAREA contains a row for this (simplified) query:
>
>SELECT * FROM ___ WHERE C1=:a AND C2=:b AND C3=:c AND C4=:d AND C5=:e;
>
>There is a primary key index on C1, C2, C3.
>
>The explain plan does show an index unique scan using the primary key
>index.
>
>The V$SQLAREA stats for this statement are:
>EXECUTIONS = 1,471,320
>ROWS_PROCESSED = 37,291,384
>
>How is it possible to use a unique index scan and return more than 1 row
>per execution? Or is there a problem with the stats?

that is a bug in the v$sqlarea table, it is fixed in 8.0.6 on up....

it is broken in 8.0.5 on down...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Feb 26 1999 - 13:16:49 CST