Is it a bug with V$SQLAREA table?

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
[email protected]
Oracle Service Industries
Reston, VA USA

Hosted by www.Geocities.ws