Saturday, September 18, 2010

How to view PL-SQL code time taken details?

EXECU SYS.DBMS_PROFILER.START_PROFILER;
<< YOUR STATEMENT HERE >>
EXECU SYS.DBMS_PROFILER.STOP_PROFILER;

Then query following tables :-

sys.plsql_profiler_data;
sys.plsql_profiler_units;
sys.plsql_profiler_runs;

No comments:

Post a Comment