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 -----------------------------------------------------------------