Oracle 10G and ASSM

[premme...@hotmail.com]

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

[Connor McDonald]

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_...@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"

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

[premme...@hotmail.com]

Connor:

Thanks. In my work environment it is not possible to do the kind o
benchamraks you are suggesting because development servers are shared
and too many other things are going on.

I, therefore, wanted to know opinions of experts, especially since they
had pointed varous problems with ASSM in Oracle 9i in non RAC
environment.

Prem

[premme...@hotmail.com]

Connor:

Thanks. In my work environment it is not possible to do the kind o

benchmarks you are suggesting because development servers are shared

and too many other things are going on.

I, therefore, wanted to know opinions of experts , especially since
they had pointed various problems with ASSM in Oracle 9i in non RAC
environment using their own benchmarks.

Prem