How to check active sessions in Oracle database

How to check active sessions in Oracle database

Check active sessions details in Oracle

Hello friends, in this article we are going to discuss how to find the details of the currently active user session with details in the Oracle Database. To check active sessions in Oracle use the below query.

Find Active session

To check active user connection details in Oracle, we need to connect with the sys user and run the below query using v$session view.

SQL>select sid,serial#,username,osuser,machine,program,module from v$session where status='ACTIVE'

Columns Description

sid – Session identifier
serial# – Session serial number
username – Database user name
osuser – Operating system client user name
machine – Operating system machine name
program – Operating system program name
module – Name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure

Read - How to install Oracle Client step by step

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: 
https://www.linkedin.com/in/shripal-singh
Twitter: 
https://twitter.com/ocptechnology
Facebook: 
https://www.facebook.com/ocptechnology
YouTube:
https://www.youtube.com/ocptechnology

One thought on “How to check active sessions in Oracle database

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top