-
Buffer Gets stat in 9i - different?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|