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

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL performance when ompiled with debug

PL/SQL performance when ompiled with debug

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Mon, 14 Mar 2005 11:22:12 +0100
Message-ID: <d13okm$4gp$1@news.mch.sbs.de> 





Hi NG,


we had 2 occurances of problems related with pl/sql programs compiled 
with debug (oracle 9.2 on windows and solaris). In both cases the CPU 
usage of the entire application (which makes heavy use of pl/sql) almost 
doubled. After recompiling without debug everything was fine again.
Is there a general experience of the performance impact?



TIA



Stephan
Received on Mon Mar 14 2005 - 04:22:12 CST












Original text of this message













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