Oracle - Can one see how connections are distributed across the nodes? How?
posted by Babu Kunwar
Can one see how connections are distributed across the nodes? How?
Yes we can monitor how the connections are distributed across the nodes. This
can be done by using the query:
select sid, session#, username from v$session where username=user_name;
Or to get the more detail result:
SELECT
'Currently,’
|| (SELECT COUNT (*) FROM V$SESSION)
|| ' out of’
|| VP.VALUE
|| 'connections are used' AS USAGE_MESSAGE
FROM
V$PARAMETER VP
WHERE VP.NAME = 'sessions'
|
