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

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Thu, 31 Mar 2005 02:15:33 -0800 (PST)
Message-ID: <20050331101533.23579.qmail@web52602.mail.yahoo.com>

Christo,

If you execute your script on 1 node only and only 1 process with and without ASSM are you getting the same CPU used by this session?

What is the version of the db you are using? Is this cluster 1 CPU per node based, home made or it is real production cluster?

Do the different test, with possible real case scenario.

For me it is looking all in favour of ASSM. Of course this is for Solaris and HP-UX and without specific HW/SW possible problems.

If you do the test only for 1 process on one instance first you will find out the difference when no scalability issues.
Then go from there and try for more.
Be sure you are watching what is going on with the overall system statistics (sar).

Regards,
Zoran

• Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
  > I am still interested in this.
  >
  > Martic, sure lets' ignore the waits, but real times
  > speak for
  > themselves. +50% in execution time.
  >
  > And the fact that I've confirmed that L1 block
  > ownership is all from
  > the same instance is very strange. Almost smells
  > like a bug. I can't
  > even begin to imagine the nightmare of trying to
  > explain this to
  > Oracle.
  >
  > --
  > Christo Kutrovsky
  > Database/System Administrator
  > The Pythian Group
  

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Thu Mar 31 2005 - 05:19:18 CST