Members   Search   Help    Register    Login   Home
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: 22
Registered: December 2006
Junior 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 Go to previous messageGo to next message
pablolee
Messages: 1672
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: 1050
Registered: December 1999
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 04:24:39 CST 2009

Total time taken to generate the page: 0.52774 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.