OraFAQ Forum: RAC & Failsafe » Number of connected users to RAC system

Home » Server Options » RAC & Failsafe » Number of connected users to RAC system

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Number of connected users to RAC system [message #137061]

Tue, 13 September 2005 01:28

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.

Report message to a moderator

Re: Number of connected users to RAC system [message #137125 is a reply to message #137061]

Tue, 13 September 2005 06:56

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Use the GV$ views. For example:

Code: [Select all] [Show/ hide]

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

Best regards.

Frank

Report message to a moderator

Re: Number of connected users to RAC system [message #137126 is a reply to message #137125]

Tue, 13 September 2005 06:58

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

Report message to a moderator

Re: Number of connected users to RAC system [message #137135 is a reply to message #137126]

Tue, 13 September 2005 07:12

Frank Naude
Messages: 4596
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 16:58:14 CDT 2025