RAC
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment