Home » RDBMS Server » Performance Tuning » Dynamic SQL performance (Oracle 10G)
Dynamic SQL performance [message #496543] Mon, 28 February 2011 17:11 Go to next message
uicmxz
Messages: 48
Registered: July 2006
Member
We experienced performance issue during execution PL/SQl code. The run time is more than 10 hours. We are using Dynamic SQL in the package. Could dynamic SQL decrease the performance?
Re: Dynamic SQL performance [message #496546 is a reply to message #496543] Mon, 28 February 2011 17:19 Go to previous message
BlackSwan
Messages: 22690
Registered: January 2009
Senior Member
>Could dynamic SQL decrease the performance?
yes, it will.

http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Previous Topic: faster processing of records needed: performance isue
Next Topic: Collecting stats
Goto Forum:
  


Current Time: Fri Aug 22 12:55:18 CDT 2014

Total time taken to generate the page: 0.09439 seconds