compile debug overhead

From: Manfred Bauer <Manfred.Bauer_at_masgmbh.com>
Date: Sun, 16 Jan 2000 17:29:52 +0100
Message-ID: <3881F200.ED32393A@masgmbh.com>

Hi all,

we are planning to intoduce the PL/SQL-Debugger XPeditor SQL from Compuware.
During the demonstration of the product, the technician of Compuware told us, that
in order to debug any stored procedure on a Oracle 7 database, you must compile the stored procedure with debug option.

alter procedure xyz compile debug.

But when you do this all stored objects, which depend on this stored procedure get invalid. So you cannot do this on a production database.

So our solution is to compile all stored objects, that means all triggers, functions, prodedures and packages with the debug option after

the installation of the database user.

Can someone tell me, what is the overhead of this method?

With regards

Manfred Bauer Received on Sun Jan 16 2000 - 10:29:52 CST