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
Title: RE: dbms_debug
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
David,
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
Title: RE: dbms_debug
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
Title: RE: dbms_debug
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-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 20,
2003 12
Title: RE: dbms_debug
Nope ... it just bloats the code(p-code or m-code) size that
is.
Raj
-
Rajendra dot Jamadagni at espn dot
com Any views expressed here are
strictly personal. QOTD: Any clod can
have facts, having an opinion