Home » RDBMS Server » Performance Tuning » Confusion over Keep Cache (2 Merged) (Oracle 11g, HP-UX B11.23)
Confusion over Keep Cache (2 Merged) [message #489385] Sat, 15 January 2011 10:36 Go to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
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.



Re: Confusion over Keep Cache [message #489387 is a reply to message #489385] Sat, 15 January 2011 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://forums.oracle.com/forums/thread.jspa?threadID=2158769&tstart=0
Re: Confusion over Keep Cache (2 Merged) [message #489389 is a reply to message #489385] Sat, 15 January 2011 10:56 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All these kinds of questions are answered in Database Concepts.

Regards
Michel
Previous Topic: Retreiving from the Data is slow
Next Topic: MEMORY_TARGET and MEMORY_MAX_TARGET
Goto Forum:
  


Current Time: Fri Mar 29 03:24:46 CDT 2024