Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: finding a session that is running a sql

Re: finding a session that is running a sql

From: <fitzjarrell_at_cox.net>
Date: 11 May 2007 06:36:09 -0700
Message-ID: <1178890569.502527.280290@e65g2000hsc.googlegroups.com>


On May 11, 8:31 am, Ben <bal..._at_comcast.net> wrote:
> 9.2.0.5 EntEd AIX5L
>
> I have a SQL that is consistently being executed 5.5 million times per
> day and we can't figure out what it is that is running it. I'm
> crossing v$session and v$sqlarea for the statements hash value and no
> session ever comes up for it. I'm watching the executions in v$sqlarea
> growing but can't match it to a session while it's growing. Any ideas
> on a better method to figure out who/what is executing this sql?

You might try setting event 10046 at level 8 and examining the resulting trace files. You'll probably need to do this via a logn.sql script, since you cannot find the session or sessions executing the offending code any other way.

David Fitzjarrell Received on Fri May 11 2007 - 08:36:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US