Home » RDBMS Server » Server Administration » db_block_buffer
db_block_buffer [message #205782] Mon, 27 November 2006 09:38 Go to next message
Alps
Messages: 28
Registered: November 2006
Location: Toronto
Junior Member
Hi my shared pool size 55000000
db_block_buffer is 3200
log_buffer 1024000
db_block_size 2048
RAM 512MB

I want to increase db_block_buffer. How much should I increase so that I can get a good optimization or is there any way to calculate.

Thanks
Re: db_block_buffer [message #205784 is a reply to message #205782] Mon, 27 November 2006 09:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> How much should I increase so that I can get a good optimization
Good optimization for what?
OLTP or DSS or What?
I would rather start small or default and tune it / increase it on the need.
Re: db_block_buffer [message #205786 is a reply to message #205784] Mon, 27 November 2006 09:51 Go to previous messageGo to next message
Alps
Messages: 28
Registered: November 2006
Location: Toronto
Junior Member
This all parameters are default parameters. I am using TOAD to see the stats for this database and its showing up that I need to increase db_block_buffer size. I dont know how to start tuning buffer. Is there any calculations I need to do and from there I can go further....
Re: db_block_buffer [message #205788 is a reply to message #205786] Mon, 27 November 2006 09:54 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Apart from the documentation,
http://asktom.oracle.com/pls/ask/f?p=4950:8:16543159578685877390::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1550006372719
Previous Topic: Changing Optimizer mode
Next Topic: Identifying and extracting an old data over three years
Goto Forum:
  


Current Time: Sat Dec 03 08:13:30 CST 2016

Total time taken to generate the page: 0.17122 seconds