Count the number of sessions from the application in Oracle

Check which application cause more number of sessions and processes in Oracle

---Check the count of session for particular applications
SELECT s.program,count(*) "noofsessions" from v$session s group by s.program;

--Check the count of session based on machine name and program.

SELECT s.program,s.machine,count(*) "Noofsessions" from v$session s group by s.program,s.machine;

Count the Number of process generated by a particular application.


--Count the number of process by machine and program name
SELECT s.program,s.machine,count(p.spid) "Noofprocess" from v$session s,v$process p where
s.paddr = p.addr group by s.program,s.machine;

Check information about the client connected with Oracle database.


--- Check from which version client is connected with Oracle server database.
select OSUSER, AUTHENTICATION_TYPE,CLIENT_VERSION, count(*)
 from V$SESSION_CONNECT_INFO group by OSUSER, AUTHENTICATION_TYPE,CLIENT_VERSION;

Related posts

How to deal with ORA-00020: maximum number of processes (%s) exceeded

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database 

Công cụ tự động khai báo datafile – Oracle