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 -> Oracle Rac-question

Oracle Rac-question

From: <ohahaahr_at_hotmail.com>
Date: 23 Nov 2005 02:34:54 -0800
Message-ID: <1132742094.601461.250440@g47g2000cwa.googlegroups.com> 





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
Received on Wed Nov 23 2005 - 04:34:54 CST












Original text of this message













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