Re: kproc

Paul Bennett <spacey845_at_my-deja.com> wrote:

>[snip -- in summary, they're Oracle AIO processes]
>
>> > I have min==1 and max==10
>> >
>> > With only one client connected to the server, I have 9 oracle-owned
>> > kprocs running, all started at boot time. After disconnecting that
>> > client, I have ... erm hold on ... the same 9 kprocs running.
>> >
>> > Does this sound a bit fishy to anyone else???
>> >

 [snip]
>> >
>> I have our MAX set to 250.
>> running "pstat -a | grep aio | wc" comes up with 250, so I need to
>> increase it.
>
>Thanks.
>
>My concern was that even after all clients disconnect, the number of
>kprocs running does NOT diminish, even though the minimum required is
>set to one. That does not sound right to me, based on my limited
>knowledge. I'd've thought that with no activity, they'd drop to the
>minimum reasonably quickly (i.e. certainly in less than 24 hours!).
>
>I've just thought: Would there be one running for each (or some) of
>the Oracle processes themselves? (e.g. ora_pmon_sid, ora_lgwr_sid,
>etc).
>
>If so, I'll probably have to bump up the maximum a touch, wont I?
>
>

How this seems to work is that the min number of aio kprocs are started at boot time, owned by root.
If more are needed they are started as required , up to the maximun, and owned by the user who started them. They are not killed and continue to exist indefinitely, so that "pstat -a|grep aios|wc -l" will give the "high water mark", that is the maximum that have ever been used.

Regards,

Ted.

| Ted Linnell                 <edlinnell_at_zcslink.net.au>     |
| BSc GradDipDP CNA MACS PCP                                 |
| Nunawading, Victoria , Australia                           |
==============================================================