Re: On which Instance of the RAC is a query running

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 09 Aug 2007 14:42:16 -0000
Message-ID: <1186670536.965739.256680@e9g2000prf.googlegroups.com>

On Aug 9, 10:17 am, peter.prav..._at_gmail.com wrote:
> Is it possible for a single query to be split across different
> instance of the RAC?
> In Toad in the longops tab of the session browser the instance id of
> the query is displayed but i dont see it in the v$session_longops
> view.
> Is there any way to check which instance a particular query is running
> on.

Hi,

Parallel server (not OPS, but the query and DML parallel stuff) is automatically RAC aware, at least in 10g (and I think in 9i, too).

Use the gv$ views for RAC stuff, as they will show all instances (with an added inst_id column).

HTH, Steve Received on Thu Aug 09 2007 - 09:42:16 CDT