kthread: table is full

[Iwan Kusmayadi_1]

Hi All,


I have message in syslog.log my server, the message is kthread: table is full.

type server : HP9000 N4000
O/S version : hp-ux 11i
Database : oracle 9i

Any idea ?

[Venkatesh BL]

Check this thread: http://forums12.itrc.hp.com/service/forums/questionanswer.do?&threadId=63788

[SUDHAKAR_18]

Hi,

This messages is caused by maxusers kernel tunable not set at high enough value.
To correct this ,increase the maxusers tunable to 200.

Regards,

[Iwan Kusmayadi_1]

Hi Sudhakar,

Currenly parameter maxuser already set to 256,

is it relevant to max_thread_proc parameter ?

regards,

[SUDHAKAR_18]

Total no of users ?

Increasing the value to 300 may work.

[IG_2]

Hi,

You should set this parameter nkthread (in HP-UX 11v1 and higher) to (((NPROC*7)/4)+16) (see also Oracle 9i reference)