Re: trace files with checksum value

Dear Ed,

If an application is written in java and uses Java Stored Procedures than what you see is simple output from System.out.println that was called in stored procedure. Procedure is running in background process and background processes don't have stdout/stderr, that's why Oracle associates this handles with trace file.

Talk to application vendor once again or write simple script that will purge all trace files with this lines.

> We recently implemented a 3rd party application running on HP-UX 11,
> using Oracle 8.1.7.4, 64-bit.
> The application generates an average of 50 trace files a day.
> Around 40% of these trace files display a short message
> referring to the checksum, similar to this :

-- 
  Edgar
--
http://www.freelists.org/webpage/oracle-l