How to find Active Inactive Sessions count in Oracle Database?
Below mentioned queries can help you find the Active Inactive Sessions Count with properly formatted output to get output right:
compute sum of count(*) on status;
break on status skip 1;
select inst_id, status, count(*) from GV$session where username is not null group by inst_id, status order by 2;
break on status skip 1;
select inst_id, status, count(*) from GV$session where username is not null group by inst_id, status order by 2;
No comments:
Post a Comment