Re: 9i - ASSM
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Mar 2004 08:36:14 -0000
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@xxxxxxx>
: 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
