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,
Printable View
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,
What exactly are you looking for? :confused:
Is this what you mean?
Code: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
How can I know the IP address or hostname of the client from where the application is launched.
thanks,
Check MACHINE column on v$session system view.