- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle and memory
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
тАО11-02-2005 03:03 AM
тАО11-02-2005 03:03 AM
Re: Oracle and memory
also before you make any change you should take a few statspack reports (ask the DBA) along with OS monitoring.
Then apply the changes (usually one at a time), monitor again (OS + Oracle) and compare with the baseline.
The baseline is important for this exercise as well as when users will(!) complain about performance. At least you will have something to go back too. Most of time it's either the increase in load (average number of users /transactions) and/or new transactions.
Your perfstats reports will help you (and DBA).
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2005 10:33 AM
тАО11-03-2005 10:33 AM
Re: Oracle and memory
Your buffer cache is likely wasting memory if you still have the default for the maximum dynamic buffer cache of 50%. Also, you can avoid double buffering from Oracle and the HP-UX OS if you select the proper mount options if you have OnLineJFS, which would waste memory and create extra memory to memory transfers.
GlancePlus can show you your peak and average memory usage, so it will allow you to see how much unused memory you really have.
Since RAM access is 1000 times faster than disk access, I still think that more RAM is a great asset, but just adding it doesn't optimize performance. Optimization requires looking at the system to see what is the precise bottleneck for your particular case. You might want to get a copy of the book "HP-UX 11i Tuning and Performance" by Robert F. Sauers to better understand the tools available for examining system performance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-04-2005 03:51 AM
тАО11-04-2005 03:51 AM
Re: Oracle and memory
I have onlineJFS & GlancePlus.
The kernel params are as follows:
bufpages: 0
dbc_max_pct: 7
dbc_min_pct: 5
maxfiles: 4000
maxfiles_lim: 1024
nfile: 123000
nflocks: 2000
ninone: 34816
maxswapchunks: 8192
swapmem_on: 1
swchunks: 2048
vps_ceiling: 64
maxdsiz: 2415919104
maxdsiz_64bit: 2415919104
maxssiz: 401604608
maxsxiz_64bit: 1073741824
maxtsiz: 1073741824
maxtsiz_64bit: 1073741824
maxuprc: 3000
max_thread_proc: 4096
ntkthread: 7184
nproc: 4096
msgmap: 4098
msgmni: 4096
msgseg: 32767
msgtql: 4096
semmap: 4098
semmni: 4096
semmns: 16384
semmnu: 4092
semvmx: 32767
shmmax: 12884901888
shmmni: 1024
shmseg: 1024
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-04-2005 10:18 AM
тАО11-04-2005 10:18 AM
Re: Oracle and memory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-04-2005 10:26 AM
тАО11-04-2005 10:26 AM
Re: Oracle and memory
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 0 4096 0% 0 - 1 /dev/vg00/lvol2
dev 4096 0 4096 0% 0 - 1 /dev/vg00/swap2
dev 4096 0 4096 0% 0 - 1 /dev/vg00/swap3
dev 4096 0 4096 0% 0 - 1 /dev/vg00/swap4
reserve - 12915 -12915
memory 31561 16789 14772 53%
total 47945 29704 18241 62% - 0 -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2005 02:42 AM
тАО11-05-2005 02:42 AM
Re: Oracle and memory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2005 02:49 AM
тАО11-05-2005 02:49 AM
Re: Oracle and memory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2005 05:36 AM
тАО11-05-2005 05:36 AM
Re: Oracle and memory
1) There is a limit on how much swap the OS will use. I can't remember if it was 16 GB or 32 GB but beyond that there is not more.
2) Powerful system you got, love working with big hardware.
3) Your shmmax might be a little light for Oracle. You can go up to 25% of memory which HP-UX defines as ram plus swap. 1.2 GB of shmmax isn't going to be enough to run the kind of database a system this powerful is likely to run.
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
тАО11-05-2005 12:48 PM
тАО11-05-2005 12:48 PM
Re: Oracle and memory
You and your DBA's really need to get a handle on where the bottlenecks are and attack the problem in the order of the biggest bottlenecks.
I'll leave you with one other whackball thought. Convince your management to do development and test on an intentionally resource limited box with less than warp-speed hardware. When the algoritms are good enough to work well in that environment then they almost always scale up very well in production environments. The fact that this may greatly annoy your developers is an added bonus.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2005 06:38 PM
тАО11-05-2005 06:38 PM
Re: Oracle and memory
Thanks A. Clay.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com