| Packaged procedure tuning [message #356748] |
Sun, 02 November 2008 01:19  |
getritesh
Messages: 235
Registered: July 2006
Location: INDIA
|
Senior Member |
|
|
Hi,
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
Account_info() procedure.
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.
Thanks,
Ritesh
[Updated on: Sun, 02 November 2008 01:25] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
