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: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 20 Feb 2003 10:39:13 -0800
Message-ID: <F001.00553356.20030220103913@fatcity.com>


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

--

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

Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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 - 12:39:13 CST

Original text of this message

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