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;