oradbakar
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment