RE: Capturing long running SQL

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:lerobe_at_acxiom.co.uk]
> 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: kirti.deshpande_at_verizon.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).