Poor Performance 10gR2 HPUX 11.31

[Rigoberto Barocio_1]

Hi all,

Recently install ORacle 10gR2 10.2.0.4 on HPUX 11.31 Itanium, and have problems with connections, i change every oracle parameters sga, redo, etc, and the db have bad performance, the db hangs when more users connect, change dedicated connection to shared and viceversa, etc.. so i change the kernel parameters in the oracle installation guide, but i search for pacthes for this version of HPUX 11.31 or any who has the same problem??

Thanks a lot.

[Steven E. Protter]

Shalom,

Time to deal with the OS side:
http://docs.hp.com/en/10404/ODM_SingleinstanceOracle.pdf

http://docs.hp.com/en/5992-4222ENW/5992-4222ENW.pdf

SEP

[Duncan Edmonstone]

If you're on the Sept 08 release of 11.31 you should already have the tuneserver command.

If you do just run:

tuneserver -o

to set kernel parms suitable for oracle

If you don't have it - go here to get it:

http://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=Tune-N-Tools

As far as patches are concerned, just make sure you're on the latest quality pack:

http://www13.itrc.hp.com/service/patch/releasePage.do?BC=main|releaseIndexPage|&releaseId=0809-11.31

HTH

Duncan

[Rigoberto Barocio_1]

Does anyone has used the command tuneserver??

[patrik rybar_1]

if you have Oracle performance problems, better is start with AWR and RDA reports to see what exactly happened in the database, don't change OS parameters when you do not know exactly which one can help you ... and keep in the mind the golden rule .. do not change more things at once ;-)

[VK2COT]

Hello,

a) I use Tune-N-Tools in the labs.
However, I do it for testing and
when teaching customers.

These are the kernel parameters that
version 1 modifies:

Tunable Value Expression Changes
max_async_ports (now) 4096 Default Immed
(next boot) 27000 27000
max_thread_proc 3000 3000 Immed
maxdsiz (now) 2063835136 2063835136 Immed
(next boot) 3221225472 3221225472
maxdsiz_64bit (now) 4294967296 Default Immed
(next boot) 274877906944 274877906944
maxfiles (now) 2048 2048
(next boot) 8192 8192
maxfiles_lim (now) 4096 Default Immed
(next boot) 8192 8192
maxssiz_64bit (now) 268435456 Default Immed
(next boot) 1073741824 1073741824
maxtsiz (now) 100663296 Default Immed
(next boot) 1073741824 1073741824
maxtsiz_64bit (now) 1073741824 Default Immed
(next boot) 8589934592 8589934592
maxuprc (now) 256 Default Immed
(next boot) 27000 27000
msgmnb (now) 16384 Default Immed
(next boot) 65536 65536
msgmni (now) 512 Default Immed
(next boot) 4096 4096
msgtql (now) 1024 Default Immed
(next boot) 4096 4096
nkthread (now) 8416 Default Immed
(next boot) 250000 250000
nproc (now) 4200 Default Immed
(next boot) 30000 30000
npty (now) 60 Default
(next boot) 200 200
nstrpty (now) 60 Default
(next boot) 200 200
o_sync_is_o_dsync (now) 0 Default
(next boot) 0 0
semmni (now) 2048 Default
(next boot) 8192 8192
semmns (now) 4096 Default
(next boot) 60000 60000
semmnu (now) 256 Default
(next boot) 4096 4096
semmsl (now) 2048 Default Immed
(next boot) 128 128
semume (now) 100 Default
(next boot) 512 512
shmmax (now) 1073741824 Default Immed
(next boot) 4398046511104 4398046511104
shmmni (now) 400 Default Immed
(next boot) 4096 4096
swchunk (now) 2048 Default
(next boot) 65536 65536
vps_ceiling (now) 16 Default Immed
(next boot) 64 64
vps_chatr_ceiling (now) 1048576 Default Immed
(next boot) 4194304 4194304

There is version 2 of the Tune-N-Tools
but I did not have time to check it yet.

b) Patrick gave you a very good
and simple advice: change small
number of parameters at a time.

c) One of the HP courses is H4262S
(HP-UX Performance and Tuning).
In it, there is a nice statement worth
remembering:

QUOTE:
You only have a performance problem
if you have a performance problem!
It does not matter what the measurements
are saying.

If you have a performance problem,
you have a performance problem.
It does not matter what the measurements
are saying.
END QUOTE

In other words, do you have any issues
with the performance, or are you happy
with the server?

Do not create problems if they do not
exist :)

Cheers,

VK2COT

[VK2COT]

By the way,

What is the storage you use for the DB?

VK2COT

[Vadim Loginov]

Hi,

Monitor RAM and swap space on your system. Perhaps you have not enough RAM on your system. We had the issue like you describe and it was resolved by adding more RAM to our server.

Regards
V.

[Juan_20]

Review the values of

tunable dbc_max_pct 5
tunable dbc_min_pct 1

[Jeff Crew]

I have had some problems after an Oracle database clone if I forgot to check my init.ora parameters.

I also set some connection and DB processing parameters high for our Ora 11i ERP database (v9.2.0.6) which still should be in Oracle 10g DB.

open_cursors = 4000
session_cached_cursors = 500
processes = 950