As I mentioned in my earlier mail, there have been a few bugs associated with v$session_longops.
Please search Metalink to check if those affect your Oracle version or not. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -----Original Message----- > From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 10:30 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Capturing long running SQL > > erm... whoops, you find the strangest things in your clipboard !!!!! > > Correct pasting is as follows. > > select a.compnam, a.objid, a.sofar consumed > , to_char(a.start_time,'YY/MM/DD HH24:MI') START_TIME > , round(a.elapsed_seconds/60,1) ELAPSED_MIN, a.msg > , b.username > , c.sql_text > from v$session_longops a, v$session b, v$sqlarea c > where a.sid = b.sid > and a.serial# = b.serial# > and b.sql_address = c.address > and b.sql_hash_value = c.hash_value > and b.username not in ('SYS','SYSTEM'); > > gave me > > Table Scan Blocks Processed 164181 44 01/10/18 14:07 > 0 > Table Scan Blocks Processed : Object id = 164181: So far = 44 : Total = 44 > GNEWSO_UK > SELECT rowid, "ACXIOM"."ACXIOM_SOURCE".* FROM ACXIOM."ACXIOM_SOURCE" > Where > ACXIOM_SOURCE_TYPE_CODE > = 1003 > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
