Re: Dump file pmon_#######.trc - what's happening?

Alberto,

This looks like a situation I encountered at my other work place. Back then I had user profiles turned on ie. I had set a limit on idle time. And would always get these pmon trace files. I think they are just informational. I would always delete them and found it did no harm to the database.

HTH,
Leng.

Alberto Rivera (usfmd2ya_at_ibmmail.com) wrote:
: Oracle is creating a dump file pmon_######.trc
: every day of activity, but there IS NOT any register
: in the altert_SID.log file.
 

: The times in the file relates to the on-line activity
: (between 08:00 and 17:00 hours). The batch process,
: which runs at night, does not seem to cause any alert.
 

: The clients do a telnet and connect to the AIX server, and
: then run forms and reports connecting Oracle using SQL*Net BEQ
: (default SQL*Net protocol adapter when not multi thread server)
 

: I want to know if the dump file is a warning or there
: is something working wrong.
 

: Here is a sample:
: ===========================================================
: Dump file /workarea/pmon_33358.trc
: Oracle7 Server Release 7.2.3.0.0 - Production Release
: With the distributed and replication options
: PL/SQL Release 2.2.3.0.0 - Production
: ORACLE_HOME = /usr/oracle/orahome
: ORACLE_SID = VH1
: Oracle process number: 2 Unix process id: 33358
: System name: AIX
: Node name: pac650
: Release: 1
: Version: 4
: Machine: 00086241A600
 

: Wed Oct 23 08:56:58 1996
: Wed Oct 23 09:04:54 1996
: Wed Oct 23 10:19:48 1996
: Wed Oct 23 10:27:04 1996
: Wed Oct 23 10:36:12 1996
: Wed Oct 23 11:10:23 1996
: Wed Oct 23 11:25:02 1996
: Wed Oct 23 11:38:48 1996
: Wed Oct 23 12:43:25 1996
: Wed Oct 23 14:11:14 1996
: Wed Oct 23 12:43:25 1996
: Wed Oct 23 14:11:14 1996
: Wed Oct 23 14:28:25 1996
: Wed Oct 23 15:38:01 1996
: Wed Oct 23 17:36:39 1996
: Wed Oct 23 19:17:40 1996

--
Leng Kaing - Database Consultant
Common Sense Consulting
Phone: +61-3-9885-5829 (ext 46)
Email: leng_at_comsense.com.au
WWW: http://dingo.vut.edu.au/voug