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-----
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_debugYes , 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-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: dbms_debugif 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-----
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: dbms_debug
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: [EMAIL PROTECTED]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: [EMAIL PROTECTED] (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).
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
