Re: Algorithm for calculating extent size in LMT

Jonathan Lewis wrote:
>
> Just as an indicator - I have a note about a test I did
> some time ago where I set up two tables of 19,000 extents
> each with 'alternating' extents, so it was:
> create tableA
> create tableB
> for i in 1..19000 loop
> alter tableA add extent -- good stuff this 'execute immediate'
> alter tableB add extent
> end loop;
>
> Using two concurrent sessions to drop both table
> simultaneously took me 26 seconds, of which 13
> seconds were recorded in v$waitstat/v$session_event
> as waits for the tablespace bitmap blocks.
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Now running 3-day intensive seminars
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Dusan Bolek wrote in message
> <1e8276d6.0203050645.21ca74be_at_posting.google.com>...
> >
> >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.
> >

Similarly

SQL> create table test_table ( x number )   2 storage ( minextents 50000);
Table created.
SQL> set timing on
SQL> drop table test_table;
Elapsed: 00:00:05.09

LMT's.... Love 'em!

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."