1841352 Members
1449 Online
110179 Solutions
New Discussion

Table is full

 
SOLVED
Go to solution
Valkiria Santos
Frequent Advisor

Table is full

Hi guys,

I??d like to know wath kernel parameter I need set to message vmunix: kthread: table is full.
Nproc? Ninod? Nfile? other one? I??ve oracle 8i anda Sybase 12 in the same machine.
My o.s is 11.11.

Thanks,
Valkiria

Thanks
8 REPLIES 8
Pete Randall
Outstanding Contributor
Solution

Re: Table is full

Valkiria,

Do you have Glance installed? If so, you can check the system tables report and it should point you to the right parameter.

Pete

Pete
Bill McNAMARA_1
Honored Contributor

Re: Table is full

nkthread

post up the results of sysdef.

Later,
Bill
It works for me (tm)
Valkiria Santos
Frequent Advisor

Re: Table is full

avail used %used
nproc -276 123 45
nfile- 920 511 56

This is my values, how much you recomend to add, 30%, 50%?
In 11.11 version, this parameters reboot the system?
Valkiria Santos
Frequent Advisor

Re: Table is full

Look sysdef output.
Pete Randall
Outstanding Contributor

Re: Table is full

Valkiria,

They're pretty low. Not really knowing anything about your system I would say you could easily double them. Using SAM to increase maxusers should accomplish this since maxusers is used in the formulas for both these parameters.

HTH,
Pete

Pete
Trond Haugen
Honored Contributor

Re: Table is full

You would want to increase the parameter 'nkthread'.

Regards,
Trond
Regards,
Trond Haugen
LinkedIn
Valkiria Santos
Frequent Advisor

Re: Table is full

Tony,

I not found this parameter.
Valkiria
Pete Randall
Outstanding Contributor

Re: Table is full

Very good, Trond. I didn't connect kthread with nkthread. Using SAM to increase maxusers will also bump up nkthread thanks to the formulas.

Pete

Pete