Re: Oracle 10G and ASSM

Connor McDonald wrote:
> 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"
>
> ------------------------------------------------------------

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 Received on Mon Apr 11 2005 - 16:06:00 CDT