"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1015324060.24905.1.nnrp-14.9e984b29_at_news.demon.co.uk>...
> You haven't gone into Oracle 9 with
> Automatic Segment Space (ASS) management
> have you ? This might have some impact on
> rollback relating to updates to bitmap blocks,
> as the BMB allocation can be painful when extent
> sizes are small.
Sorry. Just after sending my post, I've realized that version is
missing. I have the same version as Nuno, 8.1.7 (.0.0) on NT4.
I've tried to reproduce my numbers, but failed. My test box is too
small and I have not enough time. So maximum number of extents I've
got while inserting 2.000.000 (80 MBs) rows in table in tablespace
with uniform extent size 8kb.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Tue Mar 05 2002 - 08:45:40 CST
