Re: ASSM in 10g RAC doesnt seem work that well

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 25 Mar 2005 03:46:42 -0800 (PST)
Message-ID: <20050325114642.81059.qmail@web52608.mail.yahoo.com>

Thanks a lot Anjo,

> ASSM will not do that many recursive SQL (data
> dictionary operations).

I understand that, but here I am not seeing them with the trace 10046.
So I said it is internal to Oracle algorithm how it is done.

> difference is made there.You could probably get
> better results with non-ASSM
> by using freelists and using large extents. Your
> difference is purely in the
> recursive SQL part.

For me it is the same speed, whatever extent size. I am not expecting that to be the problem either because I did truncate reuse storage too before the test.

Did Oracle change something from 10g?

I should go and do the test on 9i because now I am curious.

I am maybe stupid and do not get it.

Regards,
Zoran

• Anjo Kolk <anjo.kolk_at_oraperf.com> wrote:

>
> ASSM will not do that many recursive SQL (data
> dictionary operations). The
> difference is made there.You could probably get
> better results with non-ASSM
> by using freelists and using large extents. Your
> difference is purely in the
> recursive SQL part.
>
> Anjo.
> .
                

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 25 2005 - 06:50:20 CST