Database - RAC/Scalability (MOSC)

MOSC Banner

Parallel execution and RAC

edited Aug 31, 2011 3:10PM in Database - RAC/Scalability (MOSC) 9 commentsAnswered ✓
Hi All,

My DB is 11.1 and I have 2 nodes 1 and 2 in my rac.

In the batch processing, most of SQLs are executed in parallel (parallel query and parallel DML). Does my following assumption make sense or not?

Parallel execution reads data blocks into PGA instead of SGA. So cache fusion of RAC won't help for parallelized SQL.

And if the slave sesseions can't be distributed evenly across node1 and 2, it will have no obvious benefit over the single instance?

In reality, I find that most slave sessions are populated in node1 and just the coresponding qc sessions are in node2. (I queried dba_hist_active_sess to get this information)

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