Re: Process ora_iXXXX_SID 真真?????

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 22 Sep 1999 21:07:12 -0400
Message-ID: <NHnpN3aXmracsih0RCQNJcrAFZCk@4ax.com>

A copy of this was sent to Eduardo <eyanes_at_mediaplanning.com> (if that email address didn't require changing) On Wed, 22 Sep 1999 17:15:38 +0200, you wrote:

>Ok, thanks.... we think so....but ....what is the relationship between this
>processes...
>
> oracle 13221 1 0 sbre 19 ? 31:03 ora_i103_GESTION
> oracle 13223 1 0 sbre 19 ? 31:18 ora_i104_GESTION
> oracle 13219 1 0 sbre 19 ? 31:22 ora_i102_GESTION
> oracle 13217 1 0 sbre 19 ? 35:57 ora_i101_GESTION
> oracle 13225 1 1 sbre 19 ? 48:16 ora_i201_GESTION
>
>and this parameters ???
>
>dbwr_io_slaves = 4 ( the ora_i1* ???? .. i suppose )
>lgwr_io_slaves = 1 ( the ora_i2* ???? .. i suppose too....)
>
>Why this "black-box" names ???
>

ora_ is always there.
the next 4 are the process
the remainder is the SID.

for the IO slaves:

What is the slave process naming convention?

          The slave process name is ora_iNnn_<SID> where: 
  iNnn        Description                     Possible Values
  i           Denotes this is an I/O slave    "i"
  N           I/O adaptor number              1..F
  nn          Slave number                    01..0z, 10..zz


          Once slave number 0z is spawned, the next slaves are 10, 11, 12, ...

As an example, if dbwr_io_slaves=15, the following process will be started:

          ora_i101_SID ora_i102_SID ora_i103_SID ora_i104_SID
          ora_i105_SID ora_i106_SID ora_i107_SID ora_i108_SID
          ora_i109_SID ora_i10a_SID ora_i10b_SID ora_i10c_SID
          ora_i10d_SID ora_i10e_SID ora_i10f_SID

Will a process like DBWR always use the same adaptor number? Or rephrased, given a process ora_i031_<SID>, what process is this slave doing I/O for?

No, a process may not necessarily always use the same adaptor number.

here are the names of most of the others:

DBWR (A) - the database writer
LGWR (A) - the log writer
PMON (A) - the process monitor
SMON (A) - the system monitor
CKPT (O) - the checkpoint process (or thread)
ARCH (O) - the archive process (or thread)
RECO (O) - the recoverer process (or thread)

SNPnnn (P) - snapshot process
LCKnnn (P) - inter-instance locking processes

Snnn (P) - shared server process in multi-threaded server
Dnnn (P) - dispatcher process in multi-threaded server
WMON (P) - wakeup monitor process
QMNn (P) - AQ Time Manager
TRWR (P) - Trace Writer
LMON (P) - Lock Manager Monitor
LMD0 (P) - Lock Manager Daemon

>There is a TAR in Oracle Support and we haven't response yet about ora_i*
>
>Thanks... Edu.
>
>Jonathan Lewis wrote:
>
>> These are your I/O slaves
>>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Sep 22 1999 - 20:07:12 CDT