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.
This was last published in July 2009
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments