Q
Manage Learn to apply best practices and optimize your operations.

How to use V$SESSION in Oracle to see distributed queries

Learn how to use V$SESSION in Oracle, including the MACHINE column,to find the number of connections or users connected to a particular database link in this tip.

What is the query to find the number of connections or users connected to a particular database link?
Distributed queries are not like normal sessions. A user querying across a database link does not typically stay connected for a very long time. The connection only lasts as long as the query. So you'd have to catch the "connection" during the query run-time window. To see the session, you would have to query V$SESSION. This view does not show which sessions are using a database link. But you can query the MACHINE column of V$SESSION to see which users are currently querying from your other database servers.

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close