General
cancel
Showing results for 
Search instead for 
Did you mean: 

Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

Ivan-Ho
Frequent Advisor

Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

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.
hung_phanduc
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ivan-Ho
Frequent Advisor

Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

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 ?

hung_phanduc
Yogeeraj_1
Honored Contributor

Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2

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
Each and every day is a good day to learn.