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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.