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 Thu Oct 14 2004 - 16:45:56 CDT
