Re: Identifying Long Running Queries in Oracle

From: Alan <alan_at_erols.com>
Date: Fri, 15 Oct 2004 14:08:45 -0400
Message-ID: <2tai1eF1uvn0aU1@uni-berlin.de>

"Oracle Green Horn" <aprdv_at_hotmail.com> wrote in message news:f2694e4c.0410141345.1ddaa29c_at_posting.google.com...
> 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

Do you have a DBA? Received on Fri Oct 15 2004 - 13:08:45 CDT