Jeff,
AIX uses kproc processes for a variety of reasons - chief among them is to
service AIO (Async I/O) requests. Basically kproc denotes 'kernel proc' and
is also a place-holder to accumulate spare CPU cycles. So you will see a
large accumlated CPU against them, although they haven't done much...
AIO is configured using SMIT -> AIO where you configure the required number
of servers. It looks as if a fair number servers have been configured. If
you are not using Async I/O on your Databases (see init.ora), then you can
reduce the number of servers (Min and Max) - this should take effect after a
server restart. You are right - in general - that it is better to have
larger, fewer datafiles.
Hth,
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com <http://www.klove.com/>
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-----Original Message-----
Sent: Wednesday, September 26, 2001 4:35 PM
To: Multiple recipients of list ORACLE-L
According to our SA, these oracle kproc processes in AIX are there to serve
i-o
for each open datafile. Is that true? If so, would that imply that it
would be
better to have fewer, larger datafiles in the database to avoid a surfeit of
kproc processes????
icom022:/home/oracle/tune >ps auxw | grep kproc
oracle 43110 0.0 0.0 20 7120 - A Sep 06 27:57 kproc
oracle 97094 0.0 0.0 20 7120 - A Sep 06 27:40 kproc
oracle 79546 0.0 0.0 20 7120 - A Sep 06 27:39 kproc
oracle 69334 0.0 0.0 20 7120 - A Sep 06 27:32 kproc
oracle 53842 0.0 0.0 20 7120 - A Jul 09 30:39 kproc
oracle 21878 0.0 0.0 20 7120 - A Jun 17 30:05 kproc
oracle 23232 0.0 0.0 20 7120 - A Jun 01 30:33 kproc
oracle 23768 0.0 0.0 20 7120 - A Jun 01 29:27 kproc
Thanks.
--------------------------------------------
Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.
Email: [EMAIL PROTECTED]
DBA Quickplace: http://gkmqp.tce.com/tis_dba <http://gkmqp.tce.com/tis_dba>
--------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
