Re: gv$sql_shared_cursor question
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- Date: Sat, 28 Jan 2006 00:32:59 +0000
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@xxxxxxx> 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@xxxxxxxxx>
> To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
> 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?
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Jurijs
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
