Re: PMON traces -- What would cause this?

From: <skubiszewski_at_Eisner.DECUS.Org>
Date: Fri, 15 Jan 1999 18:44:41 GMT
Message-ID: <F5M6qH.K2w@news.decus.org>

In article <916347823.26558.0.nnrp-11.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> writes:
>It might help if you posted a section of the trace file.
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk

>skubiszewski_at_Eisner.DECUS.Org wrote in message ...
>>Hi! We're running Oracle v7.2.3 on HP-UX v10.01 (development
>>system.) Each and every workday, exactly 1 trace file is dropped
>>by PMON (all between 9AM-5PM.) This seems to indicate that one
>>of our developers/testers is doing something repeatedly to
>>cause it, but what? What would cause PMON to tracefile?
>>
>>I'd like to discover the source of this mystery before the
>>application they are working on goes into production.
>>
>>Thank you!
>>

Sure, not a problem. Here's one from yesterday. The only useful information (to me) is the SID (we have two databases up) and the times PMON traced. Other than that, no clues. :-(

Dump file /ora1/oracle7/product/7.2.3/rdbms/log/pmon_25142.trc Oracle7 Server Release 7.2.3.0.0 - Production Release PL/SQL Release 2.2.3.0.0 - Production
ORACLE_HOME = /ora1/oracle7/product/7.2.3 ORACLE_SID = DEVB
Oracle process number: 2 Unix process id: 25142 System name: HP-UX

Node name:      develp
Release:        B.10.01
Version:        A
Machine:        9000/887

Thu Jan 14 09:00:44 1999

Thu Jan 14 14:31:13 1999
Thu Jan 14 15:46:32 1999

Rose Received on Fri Jan 15 1999 - 12:44:41 CST