To know the statistics of pl/SQL objects

Asked By 10 points N/A Posted on -
qa-featured

Hi I am a pl/sql developer.I just want to know how can i know the statistics for a pl/sql objects like procedure and functions.pls advice

SHARE
Answered By 0 points N/A #101161

To know the statistics of pl/SQL objects

qa-featured

Hello Lewis Alberto, you need to WRAP the procedure/function for the statistics with the following operations. One is ALTER SESSION SET events "10046 trace name context forever, level 12"; Tracing the procedure/function and the other is ALTER SESSION SET events "10046 trace name context off"; Now you can see the statistics of the plans and procedures/functions. SET event 10046 is tracing mechanism. I found this link very interesting regarding your issue http://www.oracle-developer.net/display.php?id=426

Login/Register to Answer

Related Questions