| Procedure runs long time (merged) [message #488207] |
Wed, 05 January 2011 11:36  |
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  |
cookiemonster
Messages: 13958
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).
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
