Re: track session activity

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Sep 2005 08:13:02 -0700
Message-ID: <1126710782.476510.18470@z14g2000cwz.googlegroups.com>

1_T, to expand on what Sybrand said you can find all the sessions currently connected to the database for an Oracle username or the osuser via queries on v$session. Sybrand gave you the join to v$process. You can also join v$session to any of the v$sql views to see the SQL that sessions of interest are running.

See the Oracle version# Reference manual for information on the v$ dynamic performance views.

HTH -- Mark D Powell -- Received on Wed Sep 14 2005 - 10:13:02 CDT