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

Here here. That was a good answer.

I personally would do a quick check in v$session_wait to see if it's something REALLY obvious first.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4051a5de$0$3955$afc38c87_at_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 - 16:49:31 CST