Re: Algorithm for calculating extent size in LMT

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 5 Mar 2002 16:24:56 -0000
Message-ID: <1015345516.12317.0.nnrp-10.9e984b29@news.demon.co.uk>

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.

>

Received on Tue Mar 05 2002 - 10:24:56 CST