Hi,
I have some confusion about Keep Pool in Buffer Cache.

1. What is the reasoning for placing a table in the KEEP buffer pool because if it is frequently accessed, it will be around when needed (ie if it is constantly being accessed it will not age out) .

2. Would the table be still in the Default Pool if the Keep Pool is not sized and the command is being issued alter TABLE SCOTT.EMP storage (buffer_pool keep) ?

3. If the database is restarted will the table be wiped out of the Keep Pool and again be pinned to the Keep Pool ?

Please help.