OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Buffer Catche (10.2.0.1.0 Redhat Linux 4)

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

Buffer Catche [message #429690]

Thu, 05 November 2009 04:24

goracle9
Messages: 136
Registered: December 2006

Senior Member

Buffer cache writes due to setting of the obsolete parameters "fast_start_io_target", "log_checkpoint_interval" and "log_checkpoint_timeout" were consuming significant database time.

oracle recomeneds as follows

Oracle's recommended solution is to control MTTR setting using the "fast_start_mttr_target" parameter instead of the "fast_start_io_target", "log_checkpoint_interval" and "log_checkpoint_timeout" parameters.

please advise.

Report message to a moderator

Re: Buffer Catche [message #429692 is a reply to message #429690]

Thu, 05 November 2009 04:31

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Quote:

please advise.

My advice would be to follow Oracle's recommendations

[Updated on: Thu, 05 November 2009 04:32]

Report message to a moderator

Re: Buffer Catche [message #429791 is a reply to message #429690]

Thu, 05 November 2009 16:38

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

If you want to understand more of what oracle is recommending, do some googling.

The link above is a start anyway but I ain't doing your work for you.

Good luck, Kevin

Report message to a moderator

Previous Topic:	HMV scripts
Next Topic:	Tune the code without autotrace+ dictionary - fed up with DBA advice (merged 3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 03:57:37 CDT 2024