Home » RDBMS Server » Server Administration » Keep Buffer Pool (Oracle 11g)
Keep Buffer Pool [message #637572] Wed, 20 May 2015 06:14 Go to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Hi,

We create a table and set value buffer mode to "Buffer_Pool_Keep", but do not change default value "DB_KEEP_CACHE_SIZE"(DB_KEEP_CACHE_SIZE=0).
In this situation, does this mean that the keep buffer space can not be used?


Re: Keep Buffer Pool [message #637573 is a reply to message #637572] Wed, 20 May 2015 06:21 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
That is correct. Generally, I wouldn't try to use the keep or recycle pools from 11.x. I think that the buffer cache retention algorithms have been improved sufficiently that Uncle Oracle can now manage the cache better than I can.
Re: Keep Buffer Pool [message #637575 is a reply to message #637573] Wed, 20 May 2015 06:22 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:
Uncle Oracle
Very Happy
Re: Keep Buffer Pool [message #637578 is a reply to message #637572] Wed, 20 May 2015 06:31 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thank you very much Mr.Watson,

So when value of "DB_CACHE_SIZE" is equal zero(DB_CACHE_SIZE=0) and set value buffer mode to "Default" for any segment(such as table), does this mean that "Database Buffer Cache" can not be used?

Re: Keep Buffer Pool [message #637580 is a reply to message #637578] Wed, 20 May 2015 06:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You need to read up on Automatic Shared Memory Management (ASSM) and Automatic Memory Management (AMM).

--sorry, ASMM, not ASSM

[Updated on: Wed, 20 May 2015 06:54]

Report message to a moderator

Re: Keep Buffer Pool [message #637588 is a reply to message #637580] Wed, 20 May 2015 08:47 Go to previous messageGo to next message
fabi88
Messages: 112
Registered: November 2011
Senior Member
Thank you.
Re: Keep Buffer Pool [message #637591 is a reply to message #637578] Wed, 20 May 2015 09:30 Go to previous messageGo to next message
bpeasland
Messages: 51
Registered: February 2015
Location: United States
Member

fabi88 wrote on Wed, 20 May 2015 06:31
Thank you very much Mr.Watson,

So when value of "DB_CACHE_SIZE" is equal zero(DB_CACHE_SIZE=0) and set value buffer mode to "Default" for any segment(such as table), does this mean that "Database Buffer Cache" can not be used?



You can't go without the default Buffer Cache. It must exist. If you have DB_CACHE_SIZE=0, then another parameter (SGA_TARGET? MEMORY_TARGET?) needs to be set. I haven't tested it, but I do leave the possibility that Oracle could have a default value if no parameters are set to size the default Buffer Cache.


Cheers,
Brian
Re: Keep Buffer Pool [message #637600 is a reply to message #637591] Wed, 20 May 2015 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I haven't tested it, but I do leave the possibility that Oracle could have a default value if no parameters are set to size the default Buffer Cache.


Yes it is explained in the documentation. Wink

icon12.gif  Re: Keep Buffer Pool [message #637902 is a reply to message #637591] Thu, 28 May 2015 12:27 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
From the fine Oracle® Database Reference
DB_CACHE_SIZE
Quote:
If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.

If SGA_TARGET is not set, then the default is either 48 MB or 4 MB * number of CPUs, whichever is greater
Previous Topic: Database cloning issue
Next Topic: create 11g database using a template
Goto Forum:
  


Current Time: Thu Mar 28 16:13:09 CDT 2024