plz send the procedure, it may need some tuning On 21 March 2012 18:13, Ninja Li <nickli2...@gmail.com> 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 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
