Operating System - HP-UX
1831552 Members
3523 Online
110025 Solutions
New Discussion

Re: Ideal parameters for Oracle

 

Ideal parameters for Oracle

Hi,

Our HP-UX server is N4000 OS 11.0 , 4 processors, 4GB RAM, Oracle Database 8.1.7.

But our DBA ask me to increase a good value for oracle (memory, proc,...)? But I'm wondering what are good values to increase and for what parameters !!

I need your helps
Regards



5 REPLIES 5
eran maor
Honored Contributor

Re: Ideal parameters for Oracle

Hi

it is very depents on your applics.

very impotent params is :
dbc_max_pct - change it to 10
dbc_min_pct - change it to 5
this is the buffer cashe that you dont need fo rthe oracle .

i will also check this params

fs_async - 0
max_thread_proc - 2048 or more
maxdsiz - more then 2 g.b
maxssiz - 0.5 g.b
also change the maxdsiz and maxssiz for 64 bit

maxuprc - 256
nfile - 5000
nflocks - 300
nkthread - 6000
maxfiles - 512
shmem - 1

i will also advise to look at this link for info about kernel params :
http://www.docs.hp.com/hpux/onlinedocs/939/KCParms/KCparams.OverviewAll.html
love computers
V. V. Ravi Kumar_1
Respected Contributor

Re: Ideal parameters for Oracle

hi,
the following are the suggested parameters for oracle 8174.
Shared Memory:
SHMMAX 1GB
SHMMIN 1
SHMMNI 512
SHMSEG 32

Semaphores:
SEMMNS 6640
SEMMNI 3320

regds
Never Say No

Re: Ideal parameters for Oracle

Hi ,

Our parameters are :

dbc_min_pct 5
fs_async 0
max_thread_proc 64
maxdsiz 0x04000000
maxdsiz_64bit 0x0000000040000000
maxssiz 0x00800000
maxssiz_64bit 0x00800000
maxuprc 75
nfile (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))
nflocks 200
nkthread (((NPROC*7)/4)+16)
maxfiles 1024
maxfiles_lim 2048
shmem 1

Are they ok??

Regards

eran maor
Honored Contributor

Re: Ideal parameters for Oracle

Hi

It seem o.k

check also the dbc_max_pct - if the dbc_min_pct is 5 it is o.k but you need to define also the max size of the buffer cashe .

also i have to say that there isnt any guide line how to config the kernel params for a oracle system , it depents on your system .

i will advise to install mesureware to check the perofrmence of the computer every week to see if you need to change kernel value .

i gave my guide line for hp-ux 11.11 with oracle 8.1.7 but my system is for ovo system
and it is not the same like you .
love computers
Steven E. Protter
Exalted Contributor

Re: Ideal parameters for Oracle

Attached is our kmtune (kerenel parameters)output.

We are runninig Oracle 8173 and Inernet Application Server 1.0.2.2 Patch 12 on HP-UX 11.11 64 bit. We are heavily and currently patched, running xvfb for Oracle Reports X Windows.

Steve
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