Procedure runs long time (merged) [message #488207] |
Wed, 05 January 2011 11:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jesuisantony
Messages: 166 Registered: July 2006 Location: Chennai
|
Senior Member |
|
|
Hi All,
One of the applications was not getting completed for a long. When I checked in the backend using gv$sqltext, I found that the below mentioned query was there for a long time.
BEGIN CAGIF_B2C26D_AP_EXTRACT.GPC_AP_EXTRACT(:errbuf,:rc,:A0,:A1,:A2); END;
I tried to run a trace for this procedure from the test environment. But I was unable to proceed further, as it was containing the bind variables like :A0,:A1 etc. Let me know the way to generate the trace in this situation.
Regards,
Antony
|
|
|
|
Re: Procedure runs long time (merged) [message #488215 is a reply to message #488207] |
Wed, 05 January 2011 11:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Find some values you can use in place of the binds?
It's your application, you should know (or at least be able to find out) how that procedure is used and what values can be supplied for the parameters.
Personally I'd just trace the session that's actually going slow in production. Could well be it'll go fast on test (especially if you have less data in there than in production).
|
|
|
|
|