- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Memory problems on HP-UX 11i
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
тАО07-11-2002 02:51 AM
тАО07-11-2002 02:51 AM
I am a Oracle DBA from Latvia.
My server configuration is HP 9000 L1000, 1 CPU, 256 RAM.
I have a performance problem. When server is recently booted everytiging works fine, but after a while it starts to work realy slow. It is my quess, that somehow memory is filled and not freed. Therefor Oracle uses swap instead of RAM. Also I have seen errors like "fork failed with status 12" and "bus error".
Can anyone suggest me something?
I have no performance tools installed on this server.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 03:24 AM
тАО07-11-2002 03:24 AM
Re: Memory problems on HP-UX 11i
check for values of the kernel parameters
maxuprc and nproc whether they are optimum for the server and user
maxuprc-->maximum number of user processes
nproc--->maximum total number of processes.
check for the /var/adm/syslog/syslog.log file for the bus error additional information.
Also post your kernel parameter values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 03:24 AM
тАО07-11-2002 03:24 AM
Re: Memory problems on HP-UX 11i
You *really* need to add more memory. 256MB is pitifully small.
Errno 12 is an out-of-memory. You may be able to improve things slightly by adding more swap.
Check your swap utilization with:
# swapinfo -tam
Remember that you can add secondary device swap without a reboot, assuming thatyourkernel's 'maxswapchunks' doesn't need increasing. Choose swap device locations that are *not* on vg00 (with your primary one) and assign an equal swap priority to the secondary devices to arm I/O interleaving.
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 03:24 AM
тАО07-11-2002 03:24 AM
Re: Memory problems on HP-UX 11i
256MB of ram really isn't sufficient for oracle.
What version of 11 are you running, and what version of oracle?
Can you post your output from "kmtune" and "swapinfo"?
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 03:25 AM
тАО07-11-2002 03:25 AM
Re: Memory problems on HP-UX 11i
as You wrote Your machine has not to much memory which for Oracle is critical.
If Yoy don't have any performance tool you always can use sar, top, iostat, vmstat to look where the bootleneck is.
So first of all use this tool and You will have a bit of information which allow You to investigate what is wrong.
What about kernel parameters were they prepared for data base server??? What about Oracle parameter did You set it right for your hardware??
regards seba
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 03:26 AM
тАО07-11-2002 03:26 AM
Re: Memory problems on HP-UX 11i
What application is receiving a "bus error" ??
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 03:38 AM
тАО07-11-2002 03:38 AM
Re: Memory problems on HP-UX 11i
Error 12 is not enough space to spawn processes.
you can try adding additional swap.
Also you can enable swapmem_on on your kernel.
What are the values of
dbc_max_pct
dbc_min_pct
values
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 04:27 AM
тАО07-11-2002 04:27 AM
Re: Memory problems on HP-UX 11i
I will add swap space.
But how to determine, which processes are using RAM and whitch Swap space?
If all Oracle database processes (ckpt, dbw, lgwr, smon, pmon) are using Swap space, can I still expect normal performance?
Where can I download Glance trial?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 04:36 AM
тАО07-11-2002 04:36 AM
Re: Memory problems on HP-UX 11i
You can get a trial (30-day) version of Glance from the Application CDROM set. I believe that it's on the first CD.
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-11-2002 04:52 AM
тАО07-11-2002 04:52 AM
SolutionUNIX95= ps -e -o vsz,ruser,pid,args | sort -rn | more
HOWEVER, Oracle uses a lot of additional memory (called shared memory) that is not accounted for in each process (because it is shared by several processes). If you want to see paging (ie, swapping) rates, use vmstat and look at the po (page out) column. Numbers larger than 1 digit) indicate very high paging rate which means: not enough RAM.
Oracle can be configured to use massive amounts of RAM and HP-UX will accomodate this request by using the swap area. In other words, you are trading off speed for RAM. As mentioned, Oracle needs a lot of memory to work efficiently. Use 256 megs and you'll get response times in minutes. Use 2000 to 4000 megs of RAM and you'll get response times of just a few seconds.
Oracle is far too expensive to be crippled with small RAM. Do a search through the forums on Oracle and memory and you'll see a lot of valuable information. Also note that 32bit Oracle is severely limited in the amount of RAM it can use. The 64bit version of Oracle is much more suited for L1000 system. And if you add a lot of users, 1 CPU is also too small...you'll need 2-4 CPUs for good performance.
Bill Hassell, sysadmin