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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_debug

RE: dbms_debug

From: Koivu, Lisa <Lisa.Koivu_at_efairfield.com>
Date: Thu, 20 Feb 2003 11:29:25 -0800
Message-ID: <F001.005534C2.20030220112925@fatcity.com>


I have been chastised before for leaving packages compiled in debug mode before. Suppossedly it incurs a performance hit.  

Of course I was doing this through SQL*Navigator, not command line.  

And of course I have been chastised for much worse.  

Mrs. Monkey.

-----Original Message-----
Sent: Thursday, February 20, 2003 1:39 PM To: Multiple recipients of list ORACLE-L

if you recompile without DEBUG option, debug info is lost ... that is what you want right?

Raj



Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
Sent: Thursday, February 20, 2003 1:20 PM To: Multiple recipients of list ORACLE-L

List,

Does anybody have experience with dbms_debug? I ran the following, a sample:

alter FUNCTION SF_REMOVE_CHARACTER compile debug;

alter PACKAGE P_ACCOUNTS_PAYABLE_1 compile debug;

alter package P_CALC_MED_DEF compile debug body; and so on....

I can't recompile two of my packages and the Oracle tech said shutdown and start backup. When I did that and re-compiled everything was fine. The two packages had a lock on them (ora-04021). I read the Oracle docs on how to use dbms_debug but there is no information on:

  1. how do you "undo" dbms_debug, is it just re-compiling?
  2. are there performance issues with dbms_bebug?

David Ehresmann

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ehresmann, David 
  INET: David.Ehresmann_at_ps.net 

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). 



"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."

"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."

"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."

"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: Lisa.Koivu_at_efairfield.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 Thu Feb 20 2003 - 13:29:25 CST

Original text of this message

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