AIX, kprocs, and open Oracle datafiles

From: Thomas Jeff <ThomasJe_at_tce.com>
Date: Wed, 26 Sep 2001 15:30:50 -0700
Message-ID: <F001.0039A00B.20010926153518@fatcity.com>

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

---

Received on Wed Sep 26 2001 - 17:30:50 CDT