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
--
//www.freelists.org/webpage/oracle-l

Other related posts: