COLUMN address NOPRINT
COLUMN username FORMAT a12
BREAK ON address SKIP 1
SELECT
a.address
,sql_text
,osuser
,username
FROM
v$sqltext a
,v$session s
WHERE s.SQL_ADDRESS = a.ADDRESS
AND s.status = 'ACTIVE'
AND s.type
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