If its READ intensive, I would go and increase db_block_buffres suffcient enough to hold to these table to avoid I/O. If its DML oriented you need to justify other parts of memory of SGA.
Not sure, Does it make sense ?
|
Results 1 to 5 of 5
Thread: SGA and table caching
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote