-
How to pin a index in memory?
How to calculate buffer hit ratio per table?
Can someone throw some light on above questions
that I was asked in interview.
-
Using CACHE option / buffer pool keep / recycle you can cache the index in memory (like we do in table).
Buffer hit ratio per table:
If you keep only one table in BUFFER POOL RECYLE , you can calculate the hit ratio by reading the columns Consistent gets, Physical reads, and db block gets from the V$BUFFERPOOL_STATISTICS table.
Other way is mapping the block numbers from V$BH to the block numbers of a table. This I did not work out. You can try.
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
|