Tuesday 7 August 2018

Query to check Active Inactive Sessions Count | Oracle Database

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;

No comments:

Post a Comment