Showing rac-wide information (like sessions, waits, stats, etc.) is easy: just use gv$* insetead of v$* views. The gv$ views are implemented with special processes (PZ99), which are responsible for retreiving information form all nodes.
But this processes help only for monitoring (this is, doing SELECTs). To manage specific process of specific instance you usualy need to be connected to this instance.
--
Regards,
Yavor Ivanov
Senior Database Expert
Stemo Ltd
On Fri, 13 Apr 2007 14:13:19 +0300, Johnson, William L (TEIS) <WLJohnson_at_tycoelectronics.com> wrote:
> While I have not tried to kill a session from the second node of a RAC
> environment, I do know that Quest's TOAD software shows you all sessions
> in a RAC environment while using their session browser utility...
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
> Sent: Thursday, April 12, 2007 8:37 PM
> To: shivaswamykr_at_gmail.com
> Cc: Oracle-L Freelists
> Subject: Re: KIll Session in - RAC DB
>
> Shiva,
>
> You may have to wait for another year (approx) to have this in the
> database. It is going be a 11g(!) feature.
>
> -Gopal
>
>
> On 4/12/07, Shivaswamy Raghunath <shivaswamykr_at_gmail.com> wrote:
>> Hello.
>>
>> We do not seem to have a switch INST_ID for ALTER SYSTEM KILL SESSION
>> command. So, if I need to kill the session, I necessarily need to
> login to
>> the same instance in RAC.
>>
>> Has any of you have any other method so that you can kill the session
> from
>> any of the instance of the RAC database?
>>
>> Thanks,
>> Shiva
>>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2007 - 07:20:51 CDT
