Re: Is this user-id logged on?
From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1996/01/23
Message-ID: <DLnBK1.A7x_at_twisto.eng.hou.compaq.com>#1/1
Date: 1996/01/23
Message-ID: <DLnBK1.A7x_at_twisto.eng.hou.compaq.com>#1/1
Neil,
You can 'select username from v$session;' to list all user processes currently on the instance. The first six or so will be blank. These are the oracle background processes. If you want process id's or the hash address of the current sql statement being executed, simply replace 'username' with '*'. For a detailed explanation of the V$ tables look in appendix B starting on page 72. This will also show you how to look up sql statements being used by the user.
D. Kim Hughes
Managing Consultant
DRT Systems
Houston, TX
(713)868-5537
Received on Tue Jan 23 1996 - 00:00:00 CET