Home » RDBMS Server » Performance Tuning » DB Block Buffer value
DB Block Buffer value [message #275029] Thu, 18 October 2007 02:33 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hello,

Can someone please tell me how to increase the DB Block Buffer value?

Thanks Regards,

Cherish
Re: DB Block Buffer value [message #275033 is a reply to message #275029] Thu, 18 October 2007 02:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
DB_BLOCK_BUFFER
http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams036.htm#REFRN10028

what is your Oracle Version ?
if 10g then use DB_CACHE_SIZE parameter.
Re: DB Block Buffer value [message #275046 is a reply to message #275033] Thu, 18 October 2007 02:59 Go to previous message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Dear Taj,

Thanks for those replies. It helps.

Stay blessed and keep up the good work.

Cherish
Previous Topic: Processes and Sessions
Next Topic: collect Plan
Goto Forum:
  


Current Time: Sat Dec 10 14:45:00 CST 2016

Total time taken to generate the page: 0.11253 seconds