On Wednesday, March 21, 2012 10:13:26 AM UTC-6, Ninja Li wrote: > > Hi, > > I am having performance issues in Oracle 11g R2 between a procedure > running on SQLPlus and a web application. > > When I call the procedure in SQLPlus for the first time, the > performance is slow. From the second time on, the performance is very > fast. However every time I click on the web link that calls the same > backend Oracle procedure, the bad performance occurs. > > I am not sure how I should start this issue as I don't have control > over the web application setup. > > Thanks in advance. > > Nick Li
You can use the dbms_profiler package: http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_profil.htm It could reveal where the performance problem lies so you could correct it. The code probably does need to be 'tuned' but you shouldln't need to send it to someone else you don't know to get that done. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
