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

From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Thu, 27 Sep 2007 20:01:56 -0400
Message-ID: <9c9b9dc90709271701o3c544edeob724c25b527a586@mail.gmail.com>

<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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 27 2007 - 19:01:56 CDT

This message: [ Message body ]
Next message: Nancy Iles: "RAC for a newbie"
Previous message: Prasad: "Re: 9i RMAN restore to a different server with a backup from dataguard env"
In reply to: Rajeev Prabhakar: "Re: The same session run on both instances (RAC), is it normal?"
Next in thread: LS Cheng: "Re: The same session run on both instances (RAC), is it normal?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US