That's the problem with doing proper tests,
they so often produce the wrong results !
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminars
UK July / Sept
Australia July / August
Malaysia September
USA (MI) November
http://www.jlcomp.demon.co.uk/seminar.html
Connor McDonald wrote in message <3D2B34C3.1E50_at_yahoo.com>...
>
>So the quote was:
>
>"The number of extents in a locally managed tablespace has absolutely
>none (very negligible in the worst of cases) impact on performance"
>
>Could you pass this test onto the development lead...
>
>SQL> create tablespace dummy
> 2 datafile 'e:\orasw\db1\dummy.dbf' size 2001m
> 3 extent management local uniform size 32k;
>
>SQL> create user x identified by x;
>
>User created.
>
>SQL> alter user x quota 1000m on dummy;
>
>User altered.
>
>SQL> set timing on
>SQL> create table x.p ( x number ) tablespace dummy
> 2 storage ( initial 99m next 99m minextents 10 );
>
>Table created.
>
>Elapsed: 00:02:04.57
>SQL> drop table x.p;
>
>Table dropped.
>
>Elapsed: 00:01:92.14
>system_at_db1>
>
>2 MINUTES!!!! WHAT A SHAMBLES!
>
>When they put the quota system in a bitmap as well, then I'll be
>convinced :-)
>
>Cheers
>Connor
>--
>==============================
>Connor McDonald
Received on Tue Jul 09 2002 - 14:25:24 CDT
