Hp-Unix Performance tuning

[KY.Chuang]

Dear all,
I have a question about HP-Unix Performance.
My server spefic is following:
HP rp2470
CPU : 650 MHZ * 1
Memory : 2G
OS : HP11.0
Disk : 36 G
Databse : Oracle 8

How to tuning system kernel configuration , let Server has best performance.
And give the Oracle Databse have best resource to wrok.
My kernel is following:
Maxdisz : 1,073,741,824 (0x0000000040000000)
Maxdsiz_64bit : 1,073,741,824 (0x0000000040000000)
Maxssiz : 401,604,608 (0x0017F00000)
Max ssiz_64bit : 401,604,608 (0x0017F00000)
Maxtsiz : 1,073,741,824 (0x0000000040000000)
Maxtsiz_64bit : 1,073,741,824 (0x0000000040000000)
Maxuprc : 270
Maxusers : 250
Semaem : 16384
Semmni : 512
Shmmax : 4,294,967,296 (0x100000000)
Shmseg : 240
Maxfile : 1024
Maxfiles_lim : 1024

Thanks, & Regrads.

[Michael Tully]

It all depends on what application is going to be used in conjunction with oracle. You may wish to review these documents.


http://docs.oracle.com
http://docs.oracle.com/DOCS_DOT_PDF_Storage/a86566.pdf

Here is what we use on our only oracle server which is being used for data warehouse. These were the recommendations from oracle themselves.

* Configurable Parameters

STRMSGSZ 65535
dump lvol
dbc_max_pct 10
dbc_min_pct 2
ksi_alloc_max (NPROC*8)
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxssiz 134217728
maxssiz_64bit 1073741824
maxswapchunks 16384
maxuprc ((NPROC*9)/10)
msgmap (MSGTQL+2)
msgmni NPROC
msgseg 32767
msgtql NPROC
ncallout (NPROC+16)
ncsize ((8*NPROC+2048)+VX_NCSIZE)
nfile (15*NPROC+2048)
nflocks 4096
ninode (8*NPROC+2048)
nkthread (((NPROC*7)/4)+16)
nproc 4096
nstrpty 1024
nstrtel 1024
npty 1024
semmap (SEMMNI+2)
semmni 4096
semmns (SEMMNI*2)
semmnu (NPROC-4)
semvmx 32768
shmmax 4294967295
shmmni 512
shmseg 32
st_ats_enabled 0
vps_ceiling 64

[Yogeeraj_1]

hi,

The system kernel configuration will also depend on the requirements for the Oracle Release your installing. For instance, on our RP5430 with 4 GB RAM, we have the following:

* Tunable parameters

STRMSGSZ 65535
dbc_max_pct 5
dnlc_hash_locks 512
max_thread_proc 256
maxdsiz 0X40000000
maxdsiz_64bit 0X80000000
maxssiz 0X8000000
maxssiz_64bit 0X40000000
maxswapchunks 16384
maxtsiz 0X4000000
maxtsiz_64bit 0X40000000
maxuprc ((NPROC*9)/10)
maxusers 512
msgmni (NPROC)
msgseg 32767
msgtql (NPROC)
ncsize ((8*NPROC+2048)+VX_NCSIZE)
nfile (15*NPROC+2048)
nflocks 4096
ninode (8*NPROC+2048)
nstrpty 60
semmni 4096
semmns (SEMMNI*2)
semmnu (NPROC-4)
shmmax 0XF0000000
shmmni 512
shmseg 32
vps_ceiling 64

For performance, don't forget that you should also take into consideration the following issues too, like the type of database you will be having, the environment and the architecure (Multi-threaded server or Dedicated server modes)

In general, MTS is highly appropriate for an OLTP system characterised by short, frequent transactions. In an OLTP system, transactions are executed in milliseconds - nothing ever takes more than a fraction of a second. MTS on the other hand is highly inappropriate for a data warehouse. Here, you might execute a query that takes one, two, five, or more minutes. Under MTS, this would be deadly. If you have a system that is 90 percent OLTP and 10 percent 'not quite OLTP', then you can mix and match dedicated servers and MTS on the same instance. In this fashion, you can reduce the number of processes on the machine dramatically for the OLTP users, and make it so that the 'not quite OLTP' users do not monopolize their shared servers.

This is from an Oracle Perspective. I am sure others have better ideas...

Hope this helps!

Best Regards
Yogeeraj

[Tom Geudens]

Hi,
A more general guide to performance tuning can be found at : http://h21007.www2.hp.com/dspp/files/unprotected/devresource/Docs/TechPapers/UXPerfCookBook.pdf

I can recommend it !
Regards,
Tom

[Anonymous]

Tom already pointed you to my all-time-favourite;

however, make sure to adjust the hpux defaults to somewhat like
dbc_max_pct 10
dbc_min_pct 2

("We better invest mem in oracle than in buffer cache")

thx for indicating useful responses by assigning points-
Thomas

[KY.Chuang]

Thanks all experts' help...
Because this is my first time
to ask question in HP IT resource center.
And I got lots here.
Thanks.