Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

[Ivan-Ho]

Hi everybody,

Now my database system running Oracle 8.1.7 with configuration as follows:

- OS: HPUX 11i
- Database: Oracle 8.1.7
- Memory: 2GB
- Swap: 4096 MB

However, database often be down with message from GlancePlus appears like this : "File table over flow".

I want to change some OS kernel parameter, especially nfile parameter because these are very low (attach file).

Now I don't know what values is suitable?
Can I replace kernel parameter as Oracle 9.1.2 ?
(My configuration is corresponding to Oracle 9.1.2)

Pls help me ASAP.

Thanks in advanced.

[Steven E. Protter]

Any adjustments that you have made higher in your kernel will benefit you with Oracle 9.x series databases.

The problem you may run into is that you haven't bumped up the parameters enough.

If you are raising nfile don't forget maxuprc

Thats the maximum processes for a single user. That can be an issue with ias and oracle.

Here is the 9.x kernel parameters from the metalink site.

KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64
These are minnimums.

SEP

[Ivan-Ho]

Thank SEP,

These kernel parameters above I have just seen from Metalink.

But, I don't know whether these is suitable with Oracle 8.1.7 ?

[Yogeeraj_1]

hi,

we have a configuration similar to yours:
- OS: HPUX 11i
- Database: Oracle 8.1.7.4
- Memory: 4GB

our nfile is determined by the formula: (15*NPROC+2048)

giving us: 63788

hope this helps!

regards
Yogeeraj

[Eric Antunes]

Hi,

Your nfile maybe low. I had also problems in the past with this parameter and had to increase it! Do the following command (with database and apps running) to see if you have to increase it:

#sar -v 10 10

On the file-sz column you will get how much open files you have.

Resuming, I setted my nfiles to 6000, maxuprc to 300, maxusers to 150 and nproc was setted to 1220 by the formula: 20+8*MAXUSERS

You should also set your shmmax to something like 2/3 of your physical memory, so you can increase it to 1610612736...

Best Regards,

Eric Antunes