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;