Re: How to tune Oracle database on slow performance

From: david <>
Date: Thu, 10 Jan 2008 07:30:29 -0800 (PST)
Message-ID: <>

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 Received on Thu Jan 10 2008 - 09:30:29 CST

Original text of this message