Personal tools
You are here: Home → Tech → Oracle → Display Sessions
« September 2010 »
September
MoTuWeThFrSaSu
12345
6789101112
13141516171819
20212223242526
27282930
 

Display Sessions

Sometimes it's handy to get an overview who ist connected to the database. This script gives you a brief overview and aggregates same user and machine. 

SELECT username,
  machine,
  COUNT(*) "NUMBER OF SESSIONS"
FROM v$session
WHERE USERNAME IS NOT NULL
GROUP BY username,
  machine
ORDER BY 3;
Document Actions
Left arrow Previous: Calculate Freespace in ASM