Re: Identifying Long Running Queries in Oracle

Oracle Green Horn wrote:

> We are performing some load testing on our application which is
> accessing an Oracle 9i database. I have been given a task to identify
> the longest running queries during this period. Is there a way for me
> to identify these queries (including the query text) or stored
> procedures (just the name of the proc would suffice) by joining some
> V$ tables? Can some one give me such a query if any one has it handy?
> I would really really appreciate any amount of help in this regard.
>
> TIA,
> Oracle Green Horn

What version?

AWR
StatsPack
DBMS_PROFILER There are many ways.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)