- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle parameters
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
тАО03-21-2001 09:44 PM
тАО03-21-2001 09:44 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2001 09:58 PM
тАО03-21-2001 09:58 PM
Re: Oracle parameters
One HPUX kernel parameter you would want to change is shmmax which limits the amount of shared memory you can use for your Oracle SGA.
Hope this helps. Regards.
Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2001 04:24 AM
тАО03-22-2001 04:24 AM
Re: Oracle parameters
usally db_block_buffers and shared_pool_size are the first ones to be increased.
Anything else depends on your application and the distribution of your data.
If the application is doing a lot of sorts, it might be good to increase the sort_area_size.
If you use MTS, it might be an additional option to increase the number of server-processes.
First guess
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2001 05:44 PM
тАО03-22-2001 05:44 PM
Re: Oracle parameters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2001 06:13 PM
тАО03-22-2001 06:13 PM
Re: Oracle parameters
It's not mean that shmmax = phymen
but shmmax*shmmni have to big enough for oracle share memory region.
there are some document in oracle metalink state the relationship.
with oracle paramater and hp-ux share memory paramater.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2001 11:28 PM
тАО03-22-2001 11:28 PM
SolutionSHMMAX is the maximum ALLOWABLE segment size, but it is allowed to have multiple segments!
If this value is smaller than your physical memory and futher more if its smaller than your SGA size, the only result is that you'll end up with a SGA consisting of 2 or more shared-memory segments. This might inflict on the performance, (even though I haven't noticed any problems on one of my systems running with a lo value for SHMMAX ('cause of Sybase on the same machine))
The important value is DB_BLOCK_BUFFERS in your init.ora. The more active data that can fit into your buffer cache the faster your db will run.
The value for shared pool should'n make such a difference as the code you're executing today should fit in the library cache already, but if it does'nt; this is important as well.
regards
Andreas