|Packaged procedure tuning [message #356748]
||Sun, 02 November 2008 01:19
Registered: July 2006
I have a procedure named Account_info()
defined in a Package named circuit_int.This procedure calls
in all 7 packaged procedures, 2 procedures of its own package
i.e. of circuit_int and 2 of some different package and
3 of some different package.
Out of these 7 procedures which get called in
Account_info() procedure we have
Account_circuit(Account_no IN Number)procedure,
in that procedure Account no. gets passed as input
parameter to Account_circuit procedure, With one account no.
response time of Account_info() procedure is fine and
acceptable but with 15-20 Account nos. it is taking too much
time to execute and the response time is unacceptable.
Account_circuit is called inside a CURSOR FOR LOOP in
So please suggest me any way to do things correctly, so
that response time of Account_info() procedure is acceptable.
Are there and general guidelines to tune a packaged procedure?
If so please update me with these guidelines.
[Updated on: Sun, 02 November 2008 01:25]
Report message to a moderator