Re: index - performance problem

From: <michael_bialik_at_my-deja.com>
Date: Wed, 17 Nov 1999 20:22:54 GMT
Message-ID: <80v2qp$cc7$1@nnrp1.deja.com>

Hi.

Compare your init.ora files ( dev vs prod ).
Ensure that all your tables/indexes are analyzed.
Try optimizer_mode = first_rows ( default is choose )
Check for extents and 'stalled' indexes. REBUILD stalled indexes.
Check the index of ref_price table in prod. It may have 'skewed' data distribution.

HTH. Michael.

In article <PGmY3.141$dp.5249_at_nsw.nnrp.telstra.net>, "Sean Welsh" <seanw_at_order.com.au> wrote:
> Hello,
>
> I have a major drama with my Oracle 8.05 server running on NT 4.
>
> Symptoms are CPU running at 100% for extended periods. Query response
time
> has degraded substantially to near unuseable levels.
>
> My only clue is that the indexes do not seem to be being picked up by
the
> optimiser.
>
> For example in DEV which is working fine. Explain plan for select
count(*)
> from ref_price shows the use of an index whereas explain plan in PROD
which
> runs badly is suggesting that a full table scan is the plan.
>
> Table is 240,000 records and the index is there and it has been
analysed.
>
> Anyone got any ideas why this would be so?
>
> --
> Sean Welsh
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 17 1999 - 14:22:54 CST