| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: now what??
We are rebuilding a few objects, but all of the remaining buffer busy
waits are type 130/data blocks. If these waits are for data reads, is
it still advisable to increase freelists? I thought I had read that
automatic segment space management would eliminate the need to worry
about freelists. Also, Paula's comment about additional io load
concerned me - is there an additional io load with ASSM I should be
concerned about? I've been using ASSM on some databases already and
thus far, haven't seen any problems. (except with Lob's) What's the
better approach for the objects that do get rebuilt? I've been aiming
for LMT, uniform extents and ASSM, but I'll go slow with ASSM if
others have seen problems.
tia ... Robyn
On Tue, 24 Aug 2004 11:27:12 -0700 (PDT), Paul Drake
<discgolfdba_at_yahoo.com> wrote:
> --- 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.
>
> Pd
>
>
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
-- 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 - 17:07:30 CDT
 |
 |