Re: gv$sql_shared_cursor question

If I recall correctly, you even have to have at least 1 (presumably 2) parallel processes per instance to be able to query gv$ views. Otherwise you will see just data from local instance even querying GV$ views.

J.

On 1/20/06, Tanel Põder <tanel.poder.003_at_mail.ee> wrote:
> 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.
>
> ----- Original Message -----
> From: "rjamya" <rjamya_at_gmail.com>
> To: "Oracle Discussion List" <oracle-l_at_freelists.org>
> Sent: Friday, January 20, 2006 8:54 AM
> Subject: gv$sql_shared_cursor question
>
>
> > 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?
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jurijs
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l