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 aradhyulaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ahvsrinivas@cc: yahoo.com Subject: current transaction in oracle Sent by: root@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 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: current transaction in oracle
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 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Hsu, Anthony C., ,CPMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: current transaction in oracle
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 WHERE V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS(+) AND V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE(+) ORDER BY SID / spool off [EMAIL PROTECTED] 04/17/01 01:25PM 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 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Hsu, Anthony C., ,CPMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).