Message-ID: <3C6CA6F1.9030408@earthlink.net> Date: Thu, 14 Feb 2002 23:13:05 -0700 From: Chip <ocp.dba@earthlink.net> Subject: Re: [suse-oracle] Oracle 8.1.7 processes
Good process overview except for SMON and RECO:
>>oracle 5737 1 0 Feb01 ? 00:00:28 ora_smon_orapro
>>
>This is a session process. It looks out for dead sessions and cleans them up
>and also helps new ones to connect.
>
>>oracle 5739 1 0 Feb01 ? 00:00:00 ora_reco_orapro
>>
>This is the recovery process. Oracle recovers itself at start up and at
>other times when the database has gone down - this process carries out the
>recovery and also monitors the database to check to see if any recovery is
>needed.
>
From the Oracle 8.1.7 Administrator's Guide or Concepts Manual:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/manproc.htm#12468
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c07procs.htm#18128
The system monitor process (SMON) performs crash recovery, if necessary,
at instance startup. Along with the dead session clean up, SMON also
cleans up temporary segments and coalesces contiguous free extents in
dictionary-managed tablespaces.
The recoverer process (RECO) is used with distributed databases to
automatically resolve failures involving distributed transactions. If
DISTRIBUTED_TRANSACTIONS = 0 in the init.ora file, then RECO is not
created during instance startup.
Have Fun, Chip :)
This archive was generated by hypermail 2.1.0 : Thu Feb 14 2002 - 22:11:14 PST