How to modified keep_pool size
Hi experts.The recommendation from Burleson free awr analysys is pointing to a parameter keep_pool.
I have the following values, so how to modified this?
SQL> sho parameter buffer_pool
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
SQL>
You have high small table full-table scans, at 0.7 per second. Verify that your KEEP pool is sized properly to cache frequently referenced tables and indexes. Moving frequently-referenced tables and indexes to SSD or the WriteAccelerator will significantly increase the speed of small-table full-table scans.
I have the following values, so how to modified this?
SQL> sho parameter buffer_pool
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep string
buffer_pool_recycle string
SQL>
You have high small table full-table scans, at 0.7 per second. Verify that your KEEP pool is sized properly to cache frequently referenced tables and indexes. Moving frequently-referenced tables and indexes to SSD or the WriteAccelerator will significantly increase the speed of small-table full-table scans.
0