Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic SQL vs Embedded

Dynamic SQL vs Embedded

From: pauldb <luapdb_at_yahoo.com>
Date: Fri, 25 Jun 1999 02:32:39 -0800
Message-ID: <930306760.5224@www.remarq.com> 





Is there a significant performance gain to be had by using
Dynamic SQL instead of normal embedded SQL?



If the shared_pool_size is set to be large enough- the
query should not have to reparse and therefore should be
quite fast?



Any advice here?






Received on Fri Jun 25 1999 - 05:32:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US