Re: Measuring Transaction/Query Times

If you want detailed timing statistics for a specific session, then I recommend reading "Oracle System Performance Analysis Using Oracle Event 10046" at www.hotsos.com/catalog. The 10046 stuff described in this document is advertised to become part of Oracle Trace in 9i, which should make the detailed trace data even easier to get your hands on.

Cary Millsap
www.hotsos.com
Next Hotsos Clinic: April 2-4, Denver Colorado (www.hotsos.com/training/clinic)

"Bob" <orainfouk_at_yahoo.co.uk> wrote in message news:fae6910c.0203270154.21a0604b_at_posting.google.com...
> Hi all
>
> Is there anyway I can measure and audit the duration times of
> transactions and/or queries in Oracle 8i?
>
> I know that I can view current transactions and when they started by
> looking in the v$transaction table, but I can't put a trigger on that
> to audit the transaction duration. I also know that I can view recent
> SQL statements in the v$sql_area as well as various other stats, but I
> can't find out where Oracle stores duration (if indeed it does).
>
> Does anyone have any ideas or perhaps knows of some good Oracle
> monitoring/measuring products out there?
>
> Any help would be greatly appreciated.
>
> Thanks
Received on Wed Mar 27 2002 - 16:10:34 CST