Re: How to tune Oracle database 10.1.0.3.0 on slow performance
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 10 Jan 2008 09:59:05 -0800
Message-ID: <1199987926.11390@bubbleator.drizzle.com>
Date: Thu, 10 Jan 2008 09:59:05 -0800
Message-ID: <1199987926.11390@bubbleator.drizzle.com>
david wrote:
> I would also investigate the parameters as mentioned, especially the
> optimizer_index_cost_adj. This parameter's default value of 100 is not
> beneficial for an OLTP application. We have experienced the CBO
> choosing to ignore indexes due to this parameter being to high. So,
> depending on the type of application, ensure the parameters are set
> appropriately.
>
> Dave
The first step in tuning is to apply the relevant patches. I would suggest you do that first.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jan 10 2008 - 11:59:05 CST