- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- kernel parameter setting for oracle 9.2.0.2.0
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-14-2007 07:01 PM
тАО01-14-2007 07:01 PM
kernel parameter setting for oracle 9.2.0.2.0
We have set the default setting specified in oracle docs.In that shmmax is 4 gb (50% of physical memory.shmmni is 512 and shmseg is 32 .But the processwise mwemory allocation is much more than required .How can this be reduced
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-14-2007 08:37 PM
тАО01-14-2007 08:37 PM
Re: kernel parameter setting for oracle 9.2.0.2.0
Reducing Oracle memory requirements is like telling the desert to reduce the amount of sand it has.
It won't work.
I would increas shmmni to a minimum of 2048, shmseg to 2048 as well.
You can probably safely reduce shmmax to 25% of physical memory.
You will need to increase maxdsiz_64 maxtsiz_64 and maxssiz_64.
Also needing review:
nproc
maxuprc
nfile
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-14-2007 08:40 PM
тАО01-14-2007 08:40 PM
Re: kernel parameter setting for oracle 9.2.0.2.0
Reducing Oracle memory requirements is like telling the desert to reduce the amount of sand it has.
It won't work.
I would increas shmmni to a minimum of 2048, shmseg to 2048 as well.
You can probably safely reduce shmmax to 25% of physical memory.
You will need to increase maxdsiz_64 maxtsiz_64 and maxssiz_64.
Also needing review:
nproc
maxuprc
nfile
dbc_max_pct
dbc_min_pct
dbc is the OS buffer cache. The figures should be low and close to each other for raw device db installs and installs on OS other than 11.23. Some peolple have reported a performance boost with 11.23 and filesystem based databases.
I usually set dbc_max_pct=5
dbc_min_pct=3
Its very expensive in cpu for the system to shift this figure around.
Last
ninodes #should be set reasonably high.
vx_ninodes # should be set to 90% of ninodes
Your milage may vary.
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-14-2007 08:57 PM
тАО01-14-2007 08:57 PM
Re: kernel parameter setting for oracle 9.2.0.2.0
Have a look at the DOC ID 169706.1 in metalink.oracle.com there are specified the hp kernel settings.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-14-2007 09:06 PM
тАО01-14-2007 09:06 PM
Re: kernel parameter setting for oracle 9.2.0.2.0
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-14-2007 09:25 PM
тАО01-14-2007 09:25 PM
Re: kernel parameter setting for oracle 9.2.0.2.0
I am sure that shmmni and shmseg parameters tuned to approprate values will resolve the problem but experimenting with them on a production database is really difficuilt and why did you mention both parameters values as 2048 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-15-2007 09:36 PM
тАО01-15-2007 09:36 PM
Re: kernel parameter setting for oracle 9.2.0.2.0
Recently, rather than try to untangle the various pre-install requirements I have tended to use the RDA/HCVE tool (see 250262.1) e.g.
./rda.sh -T hcve
This gives a very convenient report specific to the machine I'm working on and covers kernel params, diskspace, memory, OS patches etc so I'd recommend it in a case like this.
However, I have noticed that sometimes it makes recommendations that are slightly different than those documented in the Requirements Quick Ref (see 169706.1) - does anyone with greater experience than myself have any idea why or which I should be more inclined to believe?