- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: unlockable memory question
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
Forums
Discussions
Discussions
Discussions
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
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-25-2002 09:09 AM
01-25-2002 09:09 AM
unlockable memory question
unlockable memory=4000, dmesg info ------
Memory Information:
physical page size = 4096 bytes, logical page size = 4096 bytes
Physical: 4194304 Kbytes, lockable: 3626364 Kbytes, available: 3698996 Kbytes
The issue is a lot of oracle apps seem to be contending for memory which glance is showing at a constant 97%, what I am thinking prior to ordering more memory(4-8 gig more) is setting locakable memory to 0.
Thanks,
Joe Clark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2002 09:24 AM
01-25-2002 09:24 AM
Re: unlockable memory question
You can not set lockable memory to 0 because kernel resides lockable memory moreover any process can lock memory using plock() system call
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2002 09:30 AM
01-25-2002 09:30 AM
Re: unlockable memory question
Hope this helps
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2002 09:36 AM
01-25-2002 09:36 AM
Re: unlockable memory question
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2002 09:51 AM
01-25-2002 09:51 AM
Re: unlockable memory question
Take a look at this thread to know more about unlockable_mem,
http://docs.hp.com//hpux/onlinedocs/os/KCparam.UnlockableMem.html
http://us-support3.external.hp.com/cki/bin/doc.pl/sid=77056de50d93c29218/screen=ckiDisplayDocument?docId=400000000010677
Hope this helps.
Regds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-25-2002 02:33 PM
01-25-2002 02:33 PM
Re: unlockable memory question
was unlockable_mem. I guess 2 options that are available related to freeing up more system memory, 1) change unlockable_mem to 2000 as mentioned earlier and monitor situation, 2) change unlockable_mem to 0, and let the system determine how much it will need to use for virtual memory. Both options should free up more memory for the oracle apps. Glance listing below shows what is available when
hardly any activity on system.
Total VM : 827.6mb Sys Mem : 213.6mb User Mem: 2.68gb Phys Mem: 4.00gb
Active VM: 364.4mb Buf Cache: 409.6mb Free Mem: 733.1mb
Thanks again,
Joe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2002 07:33 PM
01-26-2002 07:33 PM
Re: unlockable memory question
If you aren't having any performance issues, I would not pay much attention to memory usage, just watch PAGE OUT. If you are having peformance problems with Oracle, the biggest contributions will be found by enumerating all the SQL routines, see which ones are used the most and rank them by cost (pirmarily disk I/O). This will require EXPLAIN PLAN and the DBA to look over. The goal is to find SQL routines that perfomr serial or full table searches rather than indexed or partial searches.
Additionally, indexes will have to be rebuilt as a large number of insertions are performed as these may create a lopsided index tree and Oracle will silently ignore the index and search serially.
Finally, SGA can be resized to provide the biggest boost in performance. Make sure that the use of temp files for sorts is minimized by providing a large share and temp pool. SGA may need to be about 1500 megs for good performance and in that case, RAM should be at least 4Gb with 6-8Gb better for growth. Idelaly, Oracle should run as 64bits so that SGA and local program memory is unconstrained by 32bit limits.
Rather than trying to adjust HP-UX for inefficient application code, it is far more productive to adjust the application.
Bill Hassell, sysadmin