Re: The same session run on both instances (RAC), is it normal?

  • From: "Rumpi Gravenstein" <rgravens@xxxxxxxxx>
  • To: rprabha01@xxxxxxxxx
  • Date: Thu, 27 Sep 2007 20:01:56 -0400

<snip>

Coz you are using a gv$ view, a parallel execution is
> taking place.
>
</snip>

This is right on.  When you query a GV$ view you are querying all the
instances in the database -- effectively duplicating your query across all
the RAC nodes.  That's how the GV$ view can show what's going on in each of
the instances.

Other related posts: