finding a session that is running a sql

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?

.

Relevant Pages

  • Re: General network errors running SPs via ADO
    ... SQL Server MVP ... > My company has an application which runs audits overnight. ... > as stored procedures executed via ADO. ... > Most of the SP executions work fine, and error appears on different sets ...
    (microsoft.public.sqlserver.server)
  • Re: finding a session that is running a sql
    ... I have a SQL that is consistently being executed 5.5 million times per ... I'm watching the executions in v$sqlarea ... what is the SQL statement that you are seeing ... cost based optimizer code. ...
    (comp.databases.oracle.server)
  • Re: finding a session that is running a sql
    ... I have a SQL that is consistently being executed 5.5 million times per ... I'm watching the executions in v$sqlarea growing ... but can't match it to a session while it's growing. ... HASH and SQL_ID as well as the SID ...
    (comp.databases.oracle.server)
  • Re: finding a session that is running a sql
    ... I have a SQL that is consistently being executed 5.5 million times per ... I'm watching the executions in v$sqlarea growing ... but can't match it to a session while it's growing. ... It has SID, ADDRESS, HASH and SQL_ID ...
    (comp.databases.oracle.server)
  • Re: Overall executions at DB level
    ... SQL> SELECT SUMFROM V$SQL ... SQL executions whatsoever in your database? ... The V$SQL view only shows the SQL statements currently in the Library Cache. ...
    (comp.databases.oracle.server)