Re: now what??

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Tue, 24 Aug 2004 11:27:12 -0700 (PDT)
Message-ID: <20040824182712.67253.qmail@web20424.mail.yahoo.com>

Robyn <robyn.sands_at_gmail.com> wrote:
> Mark,

> These are primarily data buffer / 130 type
> waits and the sql causing most of them is
> cursor type junk that needs to be
> rewritten. I added freelists to a few
> objects yesterday and saw the numbers decrease
> slightly, but I believe everything that is left
> falls exactly into this category.

> sigh .. further confirmation that this is going to
> take a long, long time ...

> Robyn

Robyn,

I believe that altering the table for freelists and inittrans only affects blocks as they are unformatted. Existing blocks that are already allocated are still as they were.

a re-org of the affected tables (and their indexes, afterwards) may be in order.

hth.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 24 2004 - 13:22:52 CDT