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
:
yahoo.com Subject: current transaction in oracle
Sent by:
root@fatcity
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
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