current transaction in oracle

2001-04-17 Thread srinivas aradhyula
hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L

Re: current transaction in oracle

2001-04-17 Thread G . Plivna
: yahoo.com Subject: current transaction in oracle Sent by: root@fatcity

RE: current transaction in oracle

2001-04-17 Thread Hsu, Anthony C., ,CPMS
Try select * from sys.v_$sqlarea Anthony -Original Message- Sent: Tuesday, April 17, 2001 11:07 AM To: Multiple recipients of list ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas

RE: current transaction in oracle

2001-04-17 Thread Tim Sawmiller
set pagesize 1000 spool actual SELECT SID, TYPE, STATUS, USERNAME, SQL_TEXT, EXECUTIONS, LOCKWAIT, SERVER, OSUSER, PROCESS, MACHINE, TERMINAL, PROGRAM FROM V$SQLAREA, V$SESSION