to get trace stats for a toad SQL
alter session set statistics_level = ALL;
SELECT * FROM TABLE(dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST'));
alter session set statistics_level = ALL;
SELECT * FROM TABLE(dbms_xplan.display_cursor(null, null, 'ALLSTATS LAST'));
No comments:
Post a Comment