[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