Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i recommended kernel parameters?

SOLVED
Go to solution
Martin Mc Gahon
Occasional Visitor

Oracle 9i recommended kernel parameters?

Hello all,

I am doing an oracle DB install on a hpux system.

With the following details:

HPUX server details:
model: rp3440
processors: 4
hpux: hpux 11i (11.11) 64 bit
physical mem: 16 G
Swap: 4 G

Oracle Details:

Oracle: 9.2.0.6 for 64 bit
SGA_max_sze parameter is to be set between 12 and 15G
Number of oracle datafiles will be 5000
Number of users will be approx 30

I have already changed the following HPUX Kernel Params to the following values:

STRMSGSZ 65535
dnlc_hash_locks 512
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxssiz 134217728
maxssiz_64bit 1073741824
maxswapchunks 16384
maxtsiz 0x4000000
maxtsiz_64bit 0x40000000
maxusers 512
msgmni 4096
msgseg 32767
msgtql 4096
nstrpty 60
semmni 4096
semmns 4096
semmnu 4092
shmmax 8589934592
shmmni 512
vps_ceiling 64

And also have seen it recommended to change the following hpux kernel parameters on some related websites:

parameter: Current Recommended

nbuf 0 50000
bufpages 0 nbuf*2
default_disk_ir 0 1
maxfiles 60 4096
maxfile_lim 1024 8192
nfile 7790 8192
nflocks 4096 8192
nproc 4096 8192
ncsize 9896 25120
maxuprc 3687 nproc - 4

Fisrtly are the values of the parameters that I have already changed Ok? And secondly is it ok to change the values to the recommended parameters. I just need to know if these changes will not affect the operating systems performance to much. The main thing is also to make sure that oracle can have 5000 datafiles open at one time and that the SGA size can be set between 12 and 15G.

Any help much appreciated.

Thank You

Martin
8 REPLIES
TwoProc
Honored Contributor
Solution

Re: Oracle 9i recommended kernel parameters?

Martin, If you've really got 5000 database files - then you need to set the maxfiles parameter to at least that high (so that Oracle can start the database).
Also, your nfile needs to be the total number of files handles that the system will have open at once. So, besides holding open the original 5000 by Oracle itself - each individual PGA space (user shadow process on each users' behalf) will have many files open itself. So, if you're going to have 100 users, each with 50 or so files open per shadow process - that's another 5000 right there. This needs to be bigger.
We are the people our parents warned us about --Jimmy Buffett
Indira Aramandla
Honored Contributor

Re: Oracle 9i recommended kernel parameters?

Hi martin,

The parameter MAXDATAFILES value is stored in the CONTROL FILE upon database creation. This is the "hard" limit on the number of datafiles which can be associated with this particular database.

The parameter "DB_FILES" is specified in init.ora. This is the limit on the total number of files associated with a particular INSTANCE of a database. This parameter can be changed simply by editing the init.ora and restarting the database, it is considered a "soft" limit.

In 9i and above, it is even softer. The OS level only comes into play when you try to set db_files or maxdatafiles higher than the OS can handle.

The default and the range of values of maxdatafiles and db_files are operating system specific.
There is a limit on MAXDATAFILES. Each platform uses a port-specific number of bits to store the ORACLE file numbers. Thus, MAXDATAFILES is limited by this number. This limit is imposed by the limit on control file size (20,000 blocks) with a 4K block size. In 9i, larger block sizes are supported, thus with DB_BLOCK_SIZE=8192 there can be up to 65,534 datafiles (same limit as other platforms).

Now about SGA, there is a Variable Size component of the SGA. One of the components that comprises the Variable Sixe is the Overhead. Various parameters influence the SGA size that constitutes the overhead. Some of the init.ora parameters that inflence the overhead part of variable component are: db_files, open_cursors and processes.

Attached is a document that describes the above.

Your HPUX Kernel Parameters looks close enough to what Oracle 9.2 recommends on HP-UX 11.11. DB_FILES (MAXDATAFILES) depends on nfile and maxfiles of the kernel parameters.

And finally when you are installing Oracle 9i on a hpux system there is a BUG.
Per HP Bug (Doc ID: KBRC00003627)
NOTE: This bug is not applicable to 11.22,11.23

The default 64bit OS installation does not create a few required X library symbolic links. The following symbolic links need to be created:
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl

IA
Never give up, Keep Trying

Re: Oracle 9i recommended kernel parameters?

Hi Martin.

Oracle & HP кecommend for kernel this Ñ arameters

Alex

Re: Oracle 9i recommended kernel parameters?

But I use here these and productivity is better
Cem Tugrul
Esteemed Contributor

Re: Oracle 9i recommended kernel parameters?

Hi Martin,

Please also have look my attachment...
Also take the kernel param;

dbc_max_pct
dbc_min_pct

These are really important kernel param
while using Oracle9i.
Also consider SGA size can be increase
on high physical mem systems like yours(16Gb)

Good Luck,
Our greatest duty in this life is to help others. And please, if you can't
Cem Tugrul
Esteemed Contributor

Re: Oracle 9i recommended kernel parameters?

opsss,
attachment is here..
Our greatest duty in this life is to help others. And please, if you can't
Fred Ruffet
Honored Contributor

Re: Oracle 9i recommended kernel parameters?

There are 2 links things you may read :
. Oracle prerequisites when installing on Unix server http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=169706.1&p_showHeader=1&p_showHelp=1
. HP cookbook for Oracle http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Martin Mc Gahon
Occasional Visitor

Re: Oracle 9i recommended kernel parameters?

Hi All,

Thank you very much for the answers above. I have reviewed them and changed my OS parameters. I will not know the benefit until the system is in production. But I will ley you know how it goes and give my final settings at that stage.

Cheers

Martin