Re: help tracking down root of high executions.

Ben wrote:
> 10.2.0.2 AIX 5.2 64bit.
>
> I've got a few sql statements that are being executed once every
> centisecond or so, according to an AWR report. I can see the type of
> program that is executing the statement but our ERP system is setup in
> a way that pretty much everyone gets the same database user name, so
> it's hard to track down where or what is executing the statements.
> With my knowledge of our ERP and our database in general I can't of
> anything that should be executing this rapidly.
>
> What would be a good way to attempt to find out exactly what is
> causing this?

What is the SQL statement?

If you don't know then try this:

SELECT * FROM TABLE(dbms_xplan.display_cursor('dpcugg8dz3y5k'));

Substituting your sql_id for the one above.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org