Home » RDBMS Server » Performance Tuning » Packaged procedure tuning (Oracle,10g,Windows XP)
Packaged procedure tuning [message #356748] Sun, 02 November 2008 01:19 Go to next message
Messages: 235
Registered: July 2006
Location: INDIA
Senior Member


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.


[Updated on: Sun, 02 November 2008 01:25]

Report message to a moderator

Re: Packaged procedure tuning [message #356861 is a reply to message #356748] Sun, 02 November 2008 22:25 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
See this article for some tips on PL/SQL design

Ross Leishman
Previous Topic: alter system set events
Next Topic: Whether Statistics upto date or not
Goto Forum:

Current Time: Wed Aug 16 14:46:03 CDT 2017

Total time taken to generate the page: 0.06908 seconds