Re: Measuring Transaction/Query Times

Thanks Cary

Fantastic, exactly what I was looking for.

Regards
Bob

"Cary Millsap" <cary.millsap_at_hotsos.com> wrote in message news:<ua4h2fe1qba01f_at_corp.supernews.com>...
> 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 Thu Mar 28 2002 - 04:47:59 CST