RE: AIX, kprocs, and open Oracle datafiles

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Wed, 26 Sep 2001 18:09:44 -0700
Message-ID: <F001.0039A0EB.20010926181016@fatcity.com>

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: thomasje_at_tce.com
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: john.kanagaraj_at_hds.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). Received on Wed Sep 26 2001 - 20:09:44 CDT