Oracle-L: dynamic SQL - preformance?

From: Mohoni, Uma <Uma.Mohoni_at_emergis.com>
Date: Tue, 26 Nov 2002 05:43:54 -0800
Message-ID: <F001.0050BDAD.20021126054354@fatcity.com>

Guys,
I have a stored proc in a package which is using dynamic sql heavily which is compiled based on various conditions(passed as input parameters) and executed within the proc to fetch the necessary data. I am looking to improve the performance of the package and am wondering if removing the dynamic sql into numerous seperate procs for each condition will do that..

I am not sure I understand what exactly Oracle does when processing the dynamic sql. Is the process & cost the same as regular sql inspite of the fact that it's inside compiled code?

Many thanks in advance to those who respond..
-Uma

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_001_01C29551.DF486B30--
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohoni, Uma
INET: Uma.Mohoni_at_emergis.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 26 2002 - 07:43:54 CST