Hi,
I don't believe I am caching data anywhere specifically in the code.
The code is a procedure with following signature
and returns data to the caller from the front end web-based
application.
PROCEDURE myprocedure
(
p_product IN VARCHAR2 DEFAULT NULL,
p_agent IN VARCHAR2 DEFAULT NULL,
p_out_result OUT p_output
)
AS
BEGIN
OPEN p_output FOR
SELECT ......
FROM tab1, tab2, ......
WHERE ......
AND porduct = p_product
ANd agent = p_agent;
Thanks for your help.
Nick
On Mar 21, 12:59 pm, Jignesh Makwana <makwanajigne...@gmail.com>
wrote:
> 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
> athttp://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
