Re: Few questions about V$SQLAREA
- From: Alexander Gorbachev <gorbyx@xxxxxxxxx>
- To: john.kanagaraj@xxxxxxx
- Date: Sat, 29 Jan 2005 18:36:41 +0100
See below...
> I tend not to rely on V$SQL for a true picture of what happened. Look at
> V$SESSTAT for these figures. (How I wish Oracle would write out V$SESSTAT
> figures into the trace file before the session ends... Not even in 10g!!)
You can use trigger after logoff to collect everything you need.
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
- References:
- RE: Few questions about V$SQLAREA
- From: John Kanagaraj
Other related posts:
- » Few questions about V$SQLAREA
- » RE: Few questions about V$SQLAREA
- » Re: Few questions about V$SQLAREA
- RE: Few questions about V$SQLAREA
- From: John Kanagaraj