Re: So long insert ...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 01 Sep 2000 22:02:58 +0800
Message-ID: <39AFB712.488C@yahoo.com>

Michael J. Moore wrote:
>
> I believe that Oracle recommends not to use percent increase of 0 due to
> coalescence which performs poorly with 0%.
> Try 1%. This is probably not related to your problem.
> Mike

%increase of 1 is a very bad idea...

Ideally you DON'T want smon to come around coalescing stuff...In fact using locally managed tablespaces (in 8i) gives you an event to turn it off..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Fri Sep 01 2000 - 09:02:58 CDT