Home » RDBMS Server » Performance Tuning » Buffer Catche (10.2.0.1.0 Redhat Linux 4)
Buffer Catche [message #429690] Thu, 05 November 2009 04:24 Go to next message
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.
Re: Buffer Catche [message #429692 is a reply to message #429690] Thu, 05 November 2009 04:31 Go to previous messageGo to next message
pablolee
Messages: 2813
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 Go to previous message
Kevin Meade
Messages: 2098
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: Thu Sep 29 03:59:48 CDT 2016

Total time taken to generate the page: 0.10985 seconds