active users query

[iris]

We are having oracle application server and at backend oracle Database server.

What is the sql Query to know how many users are using the application concurrently?


thanks,

[gandolf989]

What exactly are you looking for?
Is this what you mean?

SET ECHO OFF
SET LINESIZE 132
COLUMN username FORMAT A20
COLUMN machine  FORMAT A40
COLUMN program  FORMAT A20
COLUMN cnt      FORMAT 999
SELECT username, machine, SUBSTR(program, 1, 20) program, COUNT(*) cnt
FROM v$session
WHERE username IS NOT NULL
GROUP BY username, machine, program
ORDER BY 1,2,3;
SET ECHO ON

[iris]

How can I know the IP address or hostname of the client from where the application is launched.


thanks,

[PAVB]

Check MACHINE column on v$session system view.