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 ...