To know the statistics of pl/SQL objects

Asked By lewis alberto 10 points N/A Posted on - 03/10/2012

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

• Status: Open
• Question Views: 966
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Emon Asejo 0 points N/A #101161

To know the statistics of pl/SQL objects

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

About Emon Asejo

Questions
2

Answers
18

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 03/14/2012
• Question Category: Oracle Database