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

Other related posts: