Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log

Re: Alert log

From: Christian Antognini <christian.antognini_at_trivadis.com>
Date: Thu, 22 Jul 2004 09:23:45 +0200
Message-ID: <40ff6b84@post.usenet.com>

Hi Sybrand

> There isn't anything useful for developers in the bdump
> directory or the alert, or their 'application' is a real piece of
> shit, or they don't trust you.

I see at least 3 reason to have access to bdump.

  1. When SQL trace is used to trace parallel operations the tracefile of the coordinator is stored under udump but the tracefiles of the slave processes under bdump.
  2. Some Java stored procedures uses System.out to print some logging information. When such procedures are started by a "normal" session, the tracefiles are stored under udump. When they are started by a job (DBMS_JOB) the tracefiles are stored under bdump.
  3. Some stored procedures use DBMS_SYSTEM to add custom messages to the alert.log.

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Thu Jul 22 2004 - 02:23:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US