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
select * from v$session_longops where time_remaining>0;
go to asktom.oracle.com and look for his showsql code:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:767025833873
Received on Thu Oct 14 2004 - 16:55:55 CDT
