Re: 9i - ASSM

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 5 Mar 2004 08:36:14 -0000
Message-ID: <009a01c4028c$ebb6f6d0$7002a8c0@Primary>

Note in-line

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

March 2004 Hotsos Symposium - The Burden of Proof Dynamic Sampling - an investigation
March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial April 2004 Iceland
June 2004 UK - Optimising Oracle Seminar

Original Message ----- From: "Tanel Põder" <tanel.poder.003_at_mail.ee>

: Check 10g release notes and see which ASSM related bugs they have fixed in
: that version, from there you can find out some of the problems which you
: might encounter in 9.2.
:

Good strategy, that one. Similarly, read the manuals for version X+1 if you want to find out what version X can actually do.

: And don't take these claims seriously, that ASSM is slower "because if I
: inserted 1M records into an ASSM table, the full table scan took 2 more
: seconds than with freelist managed one". Real life systems don't just bulk
: insert once and do full table scans from there.
:

On the other hand, most people do a single bulk load to get data into the test system - and this doesn't represent the way the data appears in real-life, so they get an over-optimistic view of what's going to happen. Since ASSM addresses concurrency problems by "randomly" scattering data on arrival, then you have to be MUCH more careful about how you build your test system.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Mar 05 2004 - 02:33:25 CST