Thank you ! I have already found these parameters!
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> escribió en el mensaje
news:3d54ddd0_at_dnews.tpgi.com.au...
> Why, exactly?
>
> ASSM has a performance overhead on full table scans. Given a choice
between
> freelist management and ASSM, you'd do well to stick with freelists every
> time.
>
> Full scans have to consult (ie, read) each bitmap before working out which
> data blocks to read or skip. That's extra I/O, and that overhead can be
> considerable.
>
> Definitely one to avoid therefore...
>
> UNLESS.... unless you happen to suffer from chronic freelist contention,
> when the benefits of less contention far outweigh the increased costs of
> full table scans.
>
> Regards
> HJR
>
> "srivenu" <srivenu_at_hotmail.com> wrote in message
> news:1a68177.0208092037.d810d4c_at_posting.google.com...
> > Since you are using Oracle9i, i prefer that you use AUTO SEGMENT SPACE
> MANAGEMENT
>
>
Received on Sun Aug 11 2002 - 19:23:30 CDT
