Re: where is PCTUSED in OEM?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 10 Aug 2002 19:33:51 +1000
Message-ID: <3d54ddd0@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 Sat Aug 10 2002 - 04:33:51 CDT