Home » RDBMS Server » Performance Tuning » Buffer Catche ( Redhat Linux 4)
Buffer Catche [message #429690] Thu, 05 November 2009 04:24 Go to next message
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.
Re: Buffer Catche [message #429692 is a reply to message #429690] Thu, 05 November 2009 04:31 Go to previous messageGo to next message
Messages: 2818
Registered: May 2007
Location: Scotland
Senior Member
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 Go to previous message
Kevin Meade
Messages: 2099
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
Previous Topic: HMV scripts
Next Topic: Tune the code without autotrace+ dictionary - fed up with DBA advice (merged 3)
Goto Forum:

Current Time: Wed Oct 26 01:22:03 CDT 2016

Total time taken to generate the page: 0.12652 seconds