Hi Team,
I posted a question regarding dynamic update SP earlier last week:
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9533310000346559369 And as a result of that, I have 2 versions of Stored Procedure for each SP i'm modifying. One is using EXECUTE IMMEDIATE and second using DBMS_SQL method. As the SP changes are almost finished (5 SP in total), we are thinking of the best way to test the performance and to figure out which version would use the least amount of database resource.
From searching around the web, I stumble on AUTOTRACE and seems this would be a good way to measure the SP. However i tried the below pl/sql and no result is showing.
SQL>
SQL> set autotrace on
SQL> Begin
2 FOR x in 1..1000 LOOP
3 SP_CRM_UPDATE_SERVICE(x);
4 END LOOP;
5 END;
SQL> --result not displayed
SQL>
Any other things i should look out for?
Best Regards,
Chris Tarjono