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
Messages: 48
Registered: July 2006
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
Messages: 25541
Registered: January 2009
Location: SoCal
Senior Member
>Could dynamic SQL decrease the performance?
yes, it will.

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: Wed Jul 26 12:23:10 CDT 2017

Total time taken to generate the page: 0.17100 seconds