Is there something in your code does caching of data on first run? Regards, Jignesh From: Ninja Li Sent: 21-03-2012 21:43 To: Oracle PL/SQL Subject: [PL/SQL] Performance Issue between query running on client and application 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 received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en