Re: 2-node 9iRAC --> 2nd instance performance problem

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 12 Mar 2004 22:58:15 +1100
Message-ID: <4051a5de$0$3955$afc38c87@news.optusnet.com.au>

"Ernest Siu" <ernestsiu_at_yahoo.com> wrote in message news:2833144d.0403111734.18fb9379_at_posting.google.com...
> I have set up a 2-node 9iRAC instance on W2K AS. With one instance
> running properly and the other instance having very bad performance.
> For example, a simple select on 1000000 rows takes 1st instance 30
> seconds, the 2nd one takes 15 minutes!?

Crikey. One million rows taking 30 seconds? That's pretty lousy performance before you start even looking at the second instance.

> I'm just using all default parameters and I really don't get what is
> the problem. What/where should I look for?

Better start with comparing the spfiles/init.oras. Next, best roll out statspack on each instance and visit www.oraperf.com. After that, it's a lot of fun with v$sysstat and the various 'global' statistics.

Basically, with no details about Oracle (specific) version, shared storage architecture or pretty much anything else, there's not a lot to go on here.

Regards
HJR Received on Fri Mar 12 2004 - 05:58:15 CST