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
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

Re: Packaged procedure tuning [message #356861 is a reply to message #356748] Sun, 02 November 2008 22:25 Go to previous message
rleishman
Messages: 3724
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 Dec 07 16:09:09 CST 2016

Total time taken to generate the page: 0.09270 seconds