May I know that how to find how many active sessions and inactive sessions in a single query?
Kindly share your valuable views here, so i can understand the problem.
Thanks in advance.
select inst_id,status,count(*)as cnt from gv$session group by inst_id,status order by inst_id,status; hope this will work. try it..
Sign up for STechies
Ask Question From Our Experts