Oracle-L: RE: dbms

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Thu, 20 Feb 2003 11:35:03 -0800
Message-ID: <F001.005534FA.20030220113503@fatcity.com>

Yes , that is what I did and it seemed to work. Are there any performance issues with debug after you compile with debug? thanks,
David Ehresmann.

-----Original Message-----
Sent: Thursday, February 20, 2003 12: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-----
<mailto:David.Ehresmann_at_ps.net> ]
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:

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

David Ehresmann
--

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

Author: Ehresmann, David
INET: David.Ehresmann_at_ps.net

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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: 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
---------------------------------------------------------------------

RE: dbms_debug