Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: current transaction in oracle
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 !='BACKGROUND' ORDER BY a.ADDRESS
,a.piece;
http://www.itsystems.lv/gints/dba_selects.htm#s2
Gints Plivna
srinivas aradhyula To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <ahvsrinivas@ cc: yahoo.com> Subject: current transaction in oracle Sent by: root_at_fatcity. com 01.04.17 18:06 Please respond to ORACLE-L
hi,
i am looking for a sql statement which can tell me the current sql running in oracle.
TIA
Srinivas
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: ahvsrinivas_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: G.Plivna_at_itsystems.lv Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Apr 17 2001 - 11:54:29 CDT
![]() |
![]() |