Re: now what??

--- Robyn <robyn.sands@xxxxxxxxx> 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.

Pd

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: