Re: which RAC node I am connected to
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 29 Apr 2010 10:12:57 -0700 (PDT)
Message-ID: <53cc8fd5-368e-4f28-bf51-c8723326b4fb_at_q8g2000vbm.googlegroups.com>
On Apr 29, 12:16 pm, "bill_j_c..._at_yahoo.com" <bill_j_c..._at_yahoo.com> wrote:
> A question regarding the RAC node.
>
> When using TOAD connecting to the oracle 10g RAC, in the windows
> titile bar, it shows which node the user is connecting to.
>
> When I use sqlplus (same account used for TOAD), I am trying to get
> the same info - which node I am connected to. But the account used
> doesn't have permission to query the gv$ or v$ views.
>
> Here are the questions -
>
> 1) Do I have a way to know inside sqlplus which node I am talking to ?
> 2) How TOAD know what node the account is connect to? Apparently TOAD
> is not using the gv$ or v$ as the account doesn't have access to these
> views. It must use something else.
>
> Thanks.
Date: Thu, 29 Apr 2010 10:12:57 -0700 (PDT)
Message-ID: <53cc8fd5-368e-4f28-bf51-c8723326b4fb_at_q8g2000vbm.googlegroups.com>
On Apr 29, 12:16 pm, "bill_j_c..._at_yahoo.com" <bill_j_c..._at_yahoo.com> wrote:
> A question regarding the RAC node.
>
> When using TOAD connecting to the oracle 10g RAC, in the windows
> titile bar, it shows which node the user is connecting to.
>
> When I use sqlplus (same account used for TOAD), I am trying to get
> the same info - which node I am connected to. But the account used
> doesn't have permission to query the gv$ or v$ views.
>
> Here are the questions -
>
> 1) Do I have a way to know inside sqlplus which node I am talking to ?
> 2) How TOAD know what node the account is connect to? Apparently TOAD
> is not using the gv$ or v$ as the account doesn't have access to these
> views. It must use something else.
>
> Thanks.
select sys_context('userenv','instance') from dual; Received on Thu Apr 29 2010 - 12:12:57 CDT