Re: How to tune Oracle database on slow performance

From: DA Morgan <>
Date: Thu, 10 Jan 2008 09:59:05 -0800
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Jan 10 2008 - 11:59:05 CST

Original text of this message