- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 9i on HP-UX 11i chews up all the Virtual Me...
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
тАО04-29-2003 05:28 PM
тАО04-29-2003 05:28 PM
Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
Just wondering if anyone would have any idea why I am having problems with Oracle 9i. I am running Hp-UX 11i on a K570 9000 server with 3 CPU's and 2.5Gb of RAM. Currently when Oracle is running it progressivly uses more and more virtual RAM until there is nothing left and the server crashes (We have 2Gb of Virtual RAM). We have all the "recommended" patches loaded on the server. Any suggestions would be appreciated.
Regards
Jason
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2003 05:42 PM
тАО04-29-2003 05:42 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
Note these kernel parameters:
bufpages, maxssiz, maxtsiz, nbuf, shmmax
...and post there values here.
Do you have glance installed?
You have to begin a process identification of suspected memory leak culprits. Set up a cron with glance to read the value of "Total VSS' (* total virtual statck size *) for the id'd process and note if it increases over time. Take hourly readings. Interactively, read TVSS this way:
gpm > reports > process list > double click on process > find total VSS.
To redirect into a file use the glance advisor file, then :
glance -adviser_only -syntax ./proc_mem_leak -j30
-or-
gpm >> /tmp/file
Note these files for examples:
/opt/perf/examples/adviser
/opt/perf/paperdocs/gp/C/adviser.pdf
/opt/perf/paperdocs/gp/C/metrics.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2003 05:44 PM
тАО04-29-2003 05:44 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xf0f1ed6464a6d611abdb0090277a778c,00.html
Here's another:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xa031c4c76f92d611abdb0090277a778c,00.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 10:08 AM
тАО04-30-2003 10:08 AM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 12:20 PM
тАО04-30-2003 12:20 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
Can you go ahead and post your kernel parameters and either init.ora file or run the following on your database:
column name format a20
column value format a80
set linesize 150
set pagesize 1000
select name,value from v$parameter where isdefault = 'FALSE';
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 12:56 PM
тАО04-30-2003 12:56 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
I'm not a DBA & am no Oracle expert by any means, but we faced a similar situation when we went to 11i & 9i from 11.0 & 8.1.7.
Here are some of the things we found:
"Based on Oracle Note #204510.1, starting Oracle 9.0.1, Oracle uses the largest virtual memory page size setting allowable by HP-UX for allocating process-private memory. It is designated by the value "L" (largest), and is currently 1 GB on HP-UX 11i. Before Oracle 9.0.1, Oracle uses the default page size. So there is no problem with Oracle 8.1.7 running on HP-UX11i or HP-UX11.0. Also there is no problem with Oracle 9.2.0 running on HP-UX 11.0 since the largest page size is 64K (vps_chatr_ceilling on host1 and host2 are 64K). I think that if you set up vps_chatr_ceilling to be 64K, there is no need to use "chatr +pd oracle" to reset Oracle page size. But you may need to check what is the impact on other components by reseting vps_chatr_ceilling.
By the way, I just found out that "chatr +pd oracle" changes the executable oracle's permission from "-rwsr-s--x" to "-rwxr-x--x" and non-DBA users can not connect to the database without using connect string.
So I think that changing kernel parameter may be a better approach"
AND
"The following is how the Oracle defines the virtual memory sizes:
In Oracle 9.2.0's env_rdbms.mk:
LARGE_PAGE_FLAGS=`if /usr/bin/getconf KERNEL_BITS | $(GREP) "64" > /dev/null ; then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M" ; \
else echo "" ; fi`
In Oracle 8.1.7.4's env_rdbms.mk:
LARGE_PAGE_FLAGS=`if /usr/bin/getconf KERNEL_BITS | $(GREP) "64" > /dev/null ; then echo "-Wl,+pi 16M -Wl,+padtext 1M -Wl,+pd 64M -Wl,+paddata 1M" ; \
else echo "" ; fi`
In Oracle 8.1.7.1's env_rdbms.mk:
LARGE_PAGE_FLAGS=
(Note: no value)
And then the variable LARGE_PAGE_FLAGS is passed to cc compile like
(output from relinking Oracle 9.2.0 binary)
- Linking Oracle
rm -f /oracle/product/9.2.0/rdbms/lib/oracle
cc -Wl,+s -Wl,+n +DA2.0W +DS2.0 -o /oracle/product/9.2.0/rdbms/lib/or
acle -L/oracle/product/9.2.0/rdbms/lib/ -L/oracle/product/9.2.0/lib/ `if /usr/b
in/getconf KERNEL_BITS | grep "64" > /dev/null ; \
then echo "-Wl,+pi 64M -Wl,+pd L -Wl,+padtext 16M -Wl,+paddata 1M" ; \
else echo "" ; fi` -Wl,-PF,linkorderfile -Wl,+Ostaticprediction +O2 +Omu
ltiprocessor +Oentrysched +Onolimit +ESlit +Olibcalls /oracle/product/9.2.0/rdbm
s/lib/opimai.o /oracle/product/9.2.0/rdbms/lib/ssoraed.o
....
Changing this maker file is another option to fix the problem."
We basically discovered that if you don't change either an Oracle default or a default kern parm then Oracle will suck the system dry in no time flat....sound familiar?
So check the MetaLink for 204510.1
HTH,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 06:03 PM
тАО04-30-2003 06:03 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
bufpages = 0
nbuf = 0
maxssiz = 8388608
maxtsiz = 67108864
shmmax = 67108864
I will also post the init.ora file up here as well.
Regards
Jason
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 09:37 PM
тАО04-30-2003 09:37 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
I would look like
1.As nbuf and bufpages=0,
what is the value of buffer cache on the system i.e.
dbc_pct_max & min.
For the memory of 2.5Gb,make sure the max value does not cross 15%
When the static buffer cache is zero the dbc_pct_max and bdc_pct_min act as dynamic buffer cache.
2.With your memory and swap full,
how many dedicated server processes are started.
With this load I would assume that the server is running with the dedicated server model and not the MTS.
If that is a dedicated server model,for each client connection the server starts a seperate process which uses around 30MB on an average.
If you have lot of connections then you need to check with this and plan to whether switch the model from dedicated server to MTS(Multithreaded model)
3.Do also check your amount of lockable memory.
Make sure that some kernel parameters are high and the amount of lockable memory is less on the server.
This information you can get it in the /var/adm/syslog/syslog.log file
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 09:39 PM
тАО04-30-2003 09:39 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
I would look like
1.As nbuf and bufpages=0,
what is the value of buffer cache on the system i.e.
dbc_pct_max & min.
For the memory of 2.5Gb,make sure the max value does not cross 15%
When the static buffer cache is zero the dbc_pct_max and bdc_pct_min act as dynamic buffer cache.
2.With your memory and swap full,
how many dedicated server processes are started.
With this load I would assume that the server is running with the dedicated server model and not the MTS.
If that is a dedicated server model,for each client connection the server starts a seperate process which uses around 30MB on an average.
If you have lot of connections then you need to check with this and plan to whether switch the model from dedicated server to MTS(Multithreaded model)
3.Do also check your amount of lockable memory.
Make sure that some kernel parameters are high and the amount of lockable memory is less on the server.
This information you can get it in the /var/adm/syslog/syslog.log file
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2003 09:40 PM
тАО04-30-2003 09:40 PM
Re: Oracle 9i on HP-UX 11i chews up all the Virtual Memory and crashes.
I would look like
1.As nbuf and bufpages=0,
what is the value of buffer cache on the system i.e.
dbc_pct_max & min.
For the memory of 2.5Gb,make sure the max value does not cross 15%
When the static buffer cache is zero the dbc_pct_max and bdc_pct_min act as dynamic buffer cache.
2.With your memory and swap full,
how many dedicated server processes are started.
With this load I would assume that the server is running with the dedicated server model and not the MTS.
If that is a dedicated server model,for each client connection the server starts a seperate process which uses around 30MB on an average.
If you have lot of connections then you need to check with this and plan to whether switch the model from dedicated server to MTS(Multithreaded model)
3.Do also check your amount of lockable memory.
Make sure that some kernel parameters are high and the amount of lockable memory is less on the server.
This information you can get it in the /var/adm/syslog/syslog.log file
Revert