The parallel query slaves are spawned for querying info from other RAC
nodes, it is very useful with large number of nodes.
Also, I'd like to correct myself and my earlier post - I had always thought
that when you query underlying X$ table directly, one would get the info
from all RAC instances in them (and that's why the "where inst_id =
userenv('Instance')" is in local v$views). But apparently that's not the
case. Querying X$ tables directly just gets the instance-local info.
Whenever the same objects are queried through GV$ fixed views, then the
query goes global.
Thanks for Jonathan Lewis for pointing this out.
Tanel.
On 9204/2-node RAC.
I noticed that selecting all columns for this (gv$sql_shared_cursor) view using sqlplus resulted in a plan that used parallel queries?
Why would that happen? Raj ---------------------------------------------- Got RAC? -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l