Database - RAC/Scalability (MOSC)

MOSC Banner

Queries with same explain plan takes long time on Node "b" in RAC db env compared to Node "a"

edited Oct 24, 2013 9:23PM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

We have 2 node RAC db env. for our Enterprise Datawarehouse env ( cidcslpedw01a & cidcslpedw01b are the servers name ). But we have observed that same query with same execution plan runs in less time on node a ( cidcslpedw01a ) while it takes time on node b ( cidcslpedw01b ). As per our primary analysis, all the initialization parameter, hardware configuration are same on both the nodes. Moreover execution plan of the queries are also same then why node b takes long time to execute the same query comapared to node a ?

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center