Sunday, February 14, 2016

Query to verify Number of connections connection to each node by service

Here is the query to check # of connections on each node by the service_name.

col service_name format a25
select 
inst_id,
count(*) as connections,
service_name
from 
gv$session
group by
inst_id, service_name;

No comments:

Post a Comment