Re: Oracle 10G and ASSM

premmehrotra_at_hotmail.com wrote:
>
> I am using Oracle 10G on HP UNIX 11i and Windows 2000. I have a non RAC
> database, i.e., database has only one instance.
>
> I know ASSM was introduced in Oracle 9i and had several problems, for
> example its performance in comparision to free list management was
> said to be inferior. Have these issues been resolved in Oracle 10G?
>
> My question is has anything changed in the implementation of ASSM in
> Oracle 10G from Oracle9i. Those who had reservation in using it in
> Oracle9i, do they have same opinion in Oracle 10G?
>
> Thanks a lot,
>
> Prem

I hate to be curt but I could easily write "yes, its crap" or "no, its brilliant"...but the fact is, the only person that will know if ASSM outperforms manual-SSM on *your* platform, *your* version is you.

It take only 10mins to produce some testing scripts and (say) 5 windows all running SQL Plus to get an idea of what you should be using. For example:

test 1: create small table (just a few blocks),'n' concurrent sessions inserting into it

test 2: create small table (just a few blocks),'n' concurrent sessions updating different rows in common blocks

test 3: delete, followed by insert test

etc etc

Easy to do, you can tailor them to your anticipated apps.

Bottom line - anything we post here may or may not be relevant to you.

Cheers
Connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------