hi guys.
SQL> select status, taddr, count(*) from v$session group by status, taddr;
STATUS TADDR COUNT(*)
-------- ---------------- ----------
INACTIVE C0000000DBB65460 1
ACTIVE 13
INACTIVE C0000000DBAA1DC0 1
INACTIVE C0000000DBB01550 1
INACTIVE 60
can i say that the 1st row result means that are a person not committing a transaction?
the 2nd rows = user's performing select statements?
the last row = people doing nothing at all. Not perform and query or modification.