Re: finding a session that is running a sql
- From: Valentin Minzatu <valentinminzatu@xxxxxxxxx>
- Date: 11 May 2007 08:56:48 -0700
On May 11, 10:39 am, Charles Hooper <hooperc2...@xxxxxxxxx> wrote:
On May 11, 9:31 am, Ben <bal...@xxxxxxxxxxx> 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?
Just out of curiosity, what is the SQL statement that you are seeing
executed 5.5 million times a day?
You might want to check the table level trigger code in the database
for that SQL statement. The tip that David provided to you will tell
you if the problem is caused by application level code or if it is
caused by trigger code or the cost based optimizer based on the dep=
statements in the 10046 trace file. dep=0 is application code, while
dep=1, dep=2, dep=3, ... dep=n is trigger code, space management, or
cost based optimizer code.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
If the SQL is not a select, then you can also look into auditing the
table(s).
.
- References:
- finding a session that is running a sql
- From: Ben
- Re: finding a session that is running a sql
- From: Charles Hooper
- finding a session that is running a sql
- Prev by Date: Re: referencing the outermost table from an inner view which is inside a subselect
- Next by Date: Re: finding a session that is running a sql
- Previous by thread: Re: finding a session that is running a sql
- Next by thread: Re: finding a session that is running a sql
- Index(es):
Relevant Pages
|
