CODEWITHSUNDEEP
oracle-databaseoracle12c
Siddharth Chaurasia
Siddharth Chaurasia

Reputation: 313

Current open session in Oracle

Is there any way to get the number of current open session for a particular user without having access to v$session or any dba tables?

Upvotes: 1

Views: 699

Answers (2)

Mohammad Musleh
Mohammad Musleh

Reputation: 74

You can get the number of sessions by the following OS commands 

netstat -an | grep (database port) | wc -l

Upvotes: 0

Pavel Smirnov
Pavel Smirnov

Reputation: 4799

No, there's not, since this information may not be allowed to all users of the database.

If you want to query v$session view and have any security concerns (or your DBA does), you can simply create a view on top of the standart one, filter data from it as required, and grant access on it to a user.

Upvotes: 2

Related Questions