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
--------------------------------------------
