Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Calls

PROCEDURE DBMS_DEBUG.PROBE_VERSION (major OUT BINARY_INTEGER, minor OUT BINARY_INTEGER))

Specifies major and minor version number of the package.

PROCEDURE DBMS_DEBUG.SELF_CHECK (timeout IN BINARY_INTEGER DEFAULT 60);

If this call does not return successfully in timeout seconds, an incorrect version of DBMS_DEBUG exists on the server.

FUNCTION DBMS_DEBUG.SET_TIMEOUT (timeout IN BINARY_INTEGER) RETURN BINARY_INTEGER;

Sets and returns the timeout in seconds.

FUNCTION DBMS_DEBUG.INITIALIZE (debug_session_id IN VARCHAR2 := NULL, diagnostics IN BINARY_INTEGER := 0) RETURN VARCHAR2;

Initializes debug_session_id. If no value is supplied, an ID is automatically generated. diagnostics can be either 0, for no diagnostics in the trace file, or 1, to include diagnostics. The procedure returns the session ID.

PROCEDURE DBMS_DEBUG.DEBUG_ON (no_client_side_plsql_engine BOOLEAN := TRUE, immediate BOOLEAN := FALSE);

Turns on debugging on the server, unless the first parameter is set to FALSE. If immediate is not TRUE, the session turns on debugging at the completion of the call; otherwise, debugging starts immediately.

PROCEDURE DBMS_DEBUG.DEBUG_OFF;

Turns debugging off.

PROCEDURE DBMS_DEBUG.ATTACH_SESSION (debug_session_id IN VARCHAR2, diagnostics IN BINARY_INTEGER := 0);

Notifies the debugging session about the target program. If diagnostics is not the default of 0, will generate diagnostic output.

FUNCTION DBMS_DEBUG.SYNCHRONIZE (run_info OUT runtime_info, info_requested IN BINARY_INTEGER ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page