Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How I know the Active Users in Oracle RAC Database, How I know the Active Users in Oracle RAC Database
Abdullah 2030
post Aug 23 2017, 03:33 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 23-August 17
From: Riyadh
Member No.: 52,131



Hi Expert,

How I know the Total Active Users in oracle RAC Database ?

How I know the Total IDLE Users in oracle RAC Database ?

Thanks
Go to the top of the page
 
+Quote Post
burleson
post Aug 23 2017, 05:24 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,529
Joined: 26-January 04
Member No.: 13



Hi Abdullah, and welcome to the forum!

Oracle is instrumented to track active sessions, which are loosely associated with users.

Try this query:

http://www.dba-oracle.com/t_rac_sessions_on_each_node.htm

This query will show all active SQL:

http://www.dba-oracle.com/concepts/query_a...036;session.htm

There is also a way to detect idle time for users:

http://www.dba-oracle.com/t_connect_time_i...ire_timeout.htm

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Abdullah 2030
post Aug 23 2017, 08:13 AM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 23-August 17
From: Riyadh
Member No.: 52,131



Dear Expert,

Thanks for your reply.

Two more query ..

What is the different between Idle Session and Inactive Session ?

What is the query to find Idle Session and Inactive Session in RAC environment ?

Thanks again.
Go to the top of the page
 
+Quote Post
burleson
post Aug 23 2017, 11:39 AM
Post #4


Advanced Member
***

Group: Members
Posts: 13,529
Joined: 26-January 04
Member No.: 13



Hi,

Inactive sessions become idle after the idle_time parameter is exceeded.

Please read:

http://www.dba-oracle.com/t_idle_time.htm

To see idle and inactive in RAC, just query the gv$sessions view:

http://www.dba-oracle.com/t_inactive_sessions.htm


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd September 2017 - 05:29 PM