OraFAQ Forum: Server Administration » db_block

Home » RDBMS Server » Server Administration » db_block_buffer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db_block_buffer [message #205782]

Mon, 27 November 2006 09:38

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

Report message to a moderator

Re: db_block_buffer [message #205784 is a reply to message #205782]

Mon, 27 November 2006 09:46

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: db_block_buffer [message #205786 is a reply to message #205784]

Mon, 27 November 2006 09:51

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....

Report message to a moderator

Re: db_block_buffer [message #205788 is a reply to message #205786]

Mon, 27 November 2006 09:54

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Previous Topic:	Changing Optimizer mode
Next Topic:	Identifying and extracting an old data over three years

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:51:59 CDT 2024