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.
Printable View
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.