OraFAQ Forum: Performance Tuning » DB Block Buffer value

Home » RDBMS Server » Performance Tuning » DB Block Buffer value

Thu, 18 October 2007 02:33

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

Thu, 18 October 2007 02:36

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.

Thu, 18 October 2007 02:59

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: Wed Feb 19 02:14:51 CST 2025