Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> On which Instance of the RAC is a query running

On which Instance of the RAC is a query running

From: <peter.praveen_at_gmail.com>
Date: Thu, 09 Aug 2007 07:17:46 -0700
Message-ID: <1186669066.563818.127230@r34g2000hsd.googlegroups.com>


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. Received on Thu Aug 09 2007 - 09:17:46 CDT

Original text of this message

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