Database - RAC/Scalability (MOSC)

MOSC Banner

RAC waits and Node Affinity

edited Sep 6, 2010 10:52AM in Database - RAC/Scalability (MOSC) 7 commentsAnswered
Hi

We have a query that takes about 22 second in a 2 node RAC (10g R2) environment but takes only 3 seconds in a non rac single database 10g R2) environment

TKPROF with event 10046 results are below


2-Node RAC
==========

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.01          0          0          0           0
Fetch        2     10.75      22.88      29139     209096          0           6
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4     10.75      22.90      29139     209096          0           6

Misses in library cache during parse: 0

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net more data from client                   1        0.00          0.00

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