Re: PMON Question

Hi !

There are some TRACE events which can be used to trace the background processes (in your case PMON).

But you need to restart the DB

• Allan Nelson <anelson_at_houston.rr.com> wrote:
  > I'm afraid not. There is no connection between
  > PMON's pid and user pids
  > that I know of. There is also nothing in IPC that
  > is useful.
  >
  > Allan
  > ----- Original Message -----
  > To: "Multiple recipients of list ORACLE-L"
  > <ORACLE-L_at_fatcity.com>
  > Sent: Monday, August 28, 2000 6:23 PM
  >
  >
  > > Hi All,
  > > I'm on Oracle 8.1.5, Unix, Solaris 2.6..... today
  > we had an ORA-0600 error
  > > with the following trace file message:
  > > ORA-0600: internal error code, arguments: [plio.c:
  > non-reus], [1], [], [],
  > > [], [], [], []
  > >
  > > When I did a top command in Unix, I could see that
  > the PMON process was
  > > using 24.8% of the CPU. I know that PMON handles
  > failed user processes,
  > > cleans up, releases locks, etc. Here's my
  > question... is there away to
  > > trace the Unix PID for the PMON process back to a
  > different PID of a
  > failed
  > > user job(s) that is/are being 'cleaned up' (in
  > case this happens again
  > > tomorrow before Oracle Support can get back to
  > me)?
  > >
  > > Thanks in advance,
  > >
  > > Tamara Swilley
  > > Technical Consultant
  > > AGENCY.COM
  > > P.O. Box 3600
  > > 37347 US Hwy 6
  > > Avon, Colorado 81620
  > > V (970)845-2173
  > > F (970)845-2150
  > > E tswilley_at_agency.com
  > >
  > > --
  > > Author: Tamara Swilley
  > > INET: tswilley_at_agency.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  >

  ---

  
  > > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > > (or the name of mailing list you want to be
  > removed from). You may
  > > also send the HELP command for other information
  > (like subscribing).
  >
  > --
  > Author: Allan Nelson
  > INET: anelson_at_houston.rr.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---