Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2-node 9iRAC --> 2nd instance performance problem
"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