Re: Identifying Long Running Queries in Oracle

From: Igor Racic <igor.racicC_at_freesurf.fr_no_C>
Date: Sun, 31 Oct 2004 02:11:19 +0000
Message-ID: <41842d06$0$28698$636a15ce@news.free.fr>

One approach could be looking for active sessions and their sql_address, (and maybe prev_sql_addr) and last_call_et in v$session
and then join for sql text...

Hope it helps

Igor

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
Received on Sat Oct 30 2004 - 21:11:19 CDT