different query performance cluster nodes

From: Edward Lewis <eglewis71_at_gmail.com>
Date: Thu, 28 Apr 2011 14:39:47 -0400
Message-ID: <BANLkTikTagE3MAGBw9wMrupn=o3E2bAE_Q_at_mail.gmail.com>



Hi,

     We have a 2 node rac cluster.
When I run a query on node 1, it executes in 1-2 seconds. When I run the same query on the node 2, it takes over 2 minutes.

      The query plans are different with node 1 using an index, and node 2 doing a full table scan.

        The first server has around 583K consistent gets, and 6400 physical reads. The second server has 284 consistent gets, and 88 physical reads.

          Don't know if this is an issue, but I run system statistics, but only on 1 node. I haven't been able to find anything on running system stats in a cluster. Is it necessary to run system stats on both servers ?

          Your input is appreciated.

solaris 10
rdbms, rac 10.2.0.4

 ed

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 28 2011 - 13:39:47 CDT

Original text of this message