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?

Report message to a moderator

Re: Dynamic SQL performance [message #496546 is a reply to message #496543] Mon, 28 February 2011 17:19 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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/

Report message to a moderator

Previous Topic: faster processing of records needed: performance isue
Next Topic: Collecting stats
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 21:42:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.