OraFAQ Forum: Unix » Table is full

Home » Infrastructure » Unix » Table is full (HPUX 11.11 Oracle 8.0.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table is full [message #635589]

Wed, 01 April 2015 22:50

mzainal
Messages: 54
Registered: March 2010
Location: Malaysia

Member

Hi,

Lately we are getting is error. Space and inode have free space. We don't know where to look. This is kernel parameter. Physical memory is 12G.

Name			Current value		Pending value

nclist			64100				64100
ncsize			9120				9120
ndilbuffers		30				30
nfile			100000				100000
nflocks			1000				1000
ninode			67584				67584
nkthread		44903				44903
no_lvm_disks	0					0
nproc			25650				25650
npty			200				200

Please advice what we need to change.

Thanks.

Report message to a moderator

Re: Table is full [message #635590 is a reply to message #635589]

Wed, 01 April 2015 23:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

We don't know what you do.
We don't know actual & complete error.

>Oracle 8.0.6)
REALLY?

post complete results from SQL below

SELECT * FROM V$VERSION;

Report message to a moderator

Re: Table is full [message #635594 is a reply to message #635589]

Thu, 02 April 2015 01:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Lately we are getting is error.

What error?

Report message to a moderator

Previous Topic:	sqlplus in shell
Next Topic:	Performance Bottle neck in Solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 07:21:45 CST 2024