- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Poor Performance 10gR2 HPUX 11.31
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2009 08:13 AM
тАО01-21-2009 08:13 AM
Poor Performance 10gR2 HPUX 11.31
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2009 08:30 AM
тАО01-21-2009 08:30 AM
Re: Poor Performance 10gR2 HPUX 11.31
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2009 09:39 AM
тАО01-21-2009 09:39 AM
Re: Poor Performance 10gR2 HPUX 11.31
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
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2009 07:47 PM
тАО01-21-2009 07:47 PM
Re: Poor Performance 10gR2 HPUX 11.31
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2009 11:45 PM
тАО01-21-2009 11:45 PM
Re: Poor Performance 10gR2 HPUX 11.31
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2009 01:16 AM
тАО01-22-2009 01:16 AM
Re: Poor Performance 10gR2 HPUX 11.31
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2009 01:19 AM
тАО01-22-2009 01:19 AM
Re: Poor Performance 10gR2 HPUX 11.31
What is the storage you use for the DB?
VK2COT
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2009 05:25 AM
тАО01-26-2009 05:25 AM
Re: Poor Performance 10gR2 HPUX 11.31
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2009 01:43 AM
тАО01-27-2009 01:43 AM
Re: Poor Performance 10gR2 HPUX 11.31
tunable dbc_max_pct 5
tunable dbc_min_pct 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-28-2009 07:59 AM
тАО01-28-2009 07:59 AM
Re: Poor Performance 10gR2 HPUX 11.31
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