[thelist] drinkies and networking 'round the world...
Adam Patrick
apatrick at oracular.com
Wed Feb 7 11:10:31 CST 2001
Oshkosh
> Schaumburg - 60173
> >
> > speaking of, how many evolters are in the chicagoland/milwaukee/madison
> > area?
<tip type="Oracle">
Find out what SQL statements are currently running (read: probably
taking too long)
SELECT OSUSER, SERIAL#, SQL_TEXT
FROM V$SESSION, V$SQL
WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS
AND V$SESSION.STATUS = 'ACTIVE';
</tip>
More information about the thelist
mailing list