- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 10g hangs the system when assigning 10G...
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-28-2009 09:39 AM
тАО01-28-2009 09:39 AM
HPUX 11.11 with 80G of RAM
when we start the Oracle 10g instance with SGA set to 4G it runs fine. when we set it to 10GB the system hangs/locks and we're obliged to TOC it.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-28-2009 09:49 AM
тАО01-28-2009 09:49 AM
SolutionClearly an Oracle issue. Check with metalink for fixes or maximum SGA settings.
I have heard of this behavior before, you may be exceeding the design specifications of 10g
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-28-2009 05:29 PM
тАО01-28-2009 05:29 PM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 12:38 AM
тАО01-29-2009 12:38 AM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
What are parameters that you have changed?
Since you are on oracle 10g, you may wish to read more about SGA_TARGET initialisation parameter and how it affects the SGA.
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 12:50 AM
тАО01-29-2009 12:50 AM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
Assuming you have already configured the required parameters at the OS level, configuring the Oracle database is rather "simple". For memory considerations, you must look at SGA - System Global Area, which as in Oracle 10g can be summarised as below:
When an Oracle instance is started, memory is allocated for the SGA based on the values specified in the initialisation parameter file or hard-coded in the Oracle software. Many of the parameters that control the size of the various parts of the SGA are dynamic. Normally if the parameter SGA_MAX_SIZE is specified, the total size of the all SGA areas must not exceed the value of SGA_MAX_SIZE. If the SGA_MAX_SIZE is not specified, but the SGA_TARGET is specified, Oracle automatically adjusts the sizes of the SGA components so that the total amount of memory allocated is equal to SGA_TARGET. SGA_TARGET is a dynamic parameter; it can be changed while the instance is running.
hope this helps too!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2009 04:12 AM
тАО01-29-2009 04:12 AM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
If you use Oracle Automatic Shared Memory Management it is very important that STATISTICS_LEVEL initialization parameter is set to TYPICAL or ALL. Please check these settings (default is TYPICAL)
Regards,
Vadim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2009 01:54 AM
тАО02-02-2009 01:54 AM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
What is your patchset level?
What value do you have for shmmax?
Anything in the alert.log file??
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2009 03:46 AM
тАО02-04-2009 03:46 AM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
1)Are you using the combination of hpux 11.11 and oracle 10g ???? !!!!.
Have you installed required os patches in hpux 11.11 before the installation of 10g?.
3)If you are using async io for oracle then change the minor no of /dev/async to 0x000100 and try ..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2009 06:20 AM
тАО02-09-2009 06:20 AM
Re: Oracle 10g hangs the system when assigning 10Gb of RAM
We had to replace the memory extender board.
thank you all for your help and support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2009 06:22 AM
тАО02-09-2009 06:22 AM