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