Okay, so they're finally moving to 9i here.

I have a database in 9i that is very similar to another one I have in 8i - both copies of production probably within a couple of weeks.

On a very simple query that looks up a single record by PK... 8i says it used 3 buffer gets. 9i says it used 27!

Did something fundamentally change in 9i? The plans are exactly the same. The costs are the same. The tables and indexes are the same. I checked and double-checked my results and how I got them. I used TOAD (which uses v$sqlarea) and my own package that queries V$SESSTAT.

What am I missing here?

Thanks,

- Chris