Home » Server Options » RAC & Failsafe » Number of connected users to RAC system
Number of connected users to RAC system [message #137061] Tue, 13 September 2005 01:28 Go to next message
kal_youssef
Messages: 25
Registered: September 2005
Location: canada
Junior Member

Hey guys
im new to RAC and i was wondering how do you find out the total number of connected users to the RAC system if we have 4 nodes???
Using SQL PLUS??

I cant get the statement right. Do i use connect strings or dblinks???

thanks

ky.
Re: Number of connected users to RAC system [message #137125 is a reply to message #137061] Tue, 13 September 2005 06:56 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Use the GV$ views. For example:

SQL> SELECT COUNT(*) FROM gv$session WHERE type = 'USER';


Best regards.

Frank
Re: Number of connected users to RAC system [message #137126 is a reply to message #137125] Tue, 13 September 2005 06:58 Go to previous messageGo to next message
kal_youssef
Messages: 25
Registered: September 2005
Location: canada
Junior Member

hi frank
thanks for the reply
are you sure this works?
Why am i to use the gv views?
thanks

regards

kal
Re: Number of connected users to RAC system [message #137135 is a reply to message #137126] Tue, 13 September 2005 07:12 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Why don't you test it and let us know?

Tip: There is some good info about GV$ views in the Oracle Database Reference Guide.

Best regards.

Frank
Previous Topic: Oracle RAC on Compaq TRU64- Connection Problems
Next Topic: parameter max_commit_propogation_delay in RAC env.
Goto Forum:
  


Current Time: Fri Mar 29 10:50:43 CDT 2024