Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Rac-question
ohahaahr_at_hotmail.com wrote:
> Hi !
>
> We run an Oracle RAC on 2 servers (rac1pub and rac2pub).
>
> Can I make an SQL-stament showing which users is on which server ?
>
> The reason is, that i have a killed session on rac1pub, that is
> blocking the system, and it will not go away. (it has been hanging for
> sevaral days...)
>
> Therefore I want to restart rac1pub. But I want to give the users on
> that server a warning, before i throw them off.
>
>
> Regards,
>
> Ole
Sure you can look at gv$session Received on Wed Nov 23 2005 - 07:08:37 CST
![]() |
![]() |