- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Kernel Tuning for Oracle
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
тАО09-09-2002 10:07 AM
тАО09-09-2002 10:07 AM
Thanks,
Jay
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 10:16 AM
тАО09-09-2002 10:16 AM
Re: Kernel Tuning for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 10:25 AM
тАО09-09-2002 10:25 AM
Re: Kernel Tuning for Oracle
Jay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 10:30 AM
тАО09-09-2002 10:30 AM
Re: Kernel Tuning for Oracle
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 10:32 AM
тАО09-09-2002 10:32 AM
Re: Kernel Tuning for Oracle
maxdsiz = 1GB
maxdsiz_64bit = 1.7GB
maxtsiz = 1GB
maxtsiz_64bit = 1GB
maxssiz = 200MB
maxssiz_64bit = 200MB
shmmax = 1GB
max_thread_proc
These are the main ones but there are others. Oracle has a document out that defines all of the changes. It can be found on there web site.
Ray
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 12:49 PM
тАО09-09-2002 12:49 PM
Re: Kernel Tuning for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 01:06 PM
тАО09-09-2002 01:06 PM
Re: Kernel Tuning for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 01:07 PM
тАО09-09-2002 01:07 PM
Re: Kernel Tuning for Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 01:24 PM
тАО09-09-2002 01:24 PM
Solutionmaxdsiz is only 64MB now; I would increase it to 512MB. Maxdsiz_64bit is now 1GB you probably want to increase that to about 1.5GB.
Maxssiz is only 8MB; I would bump it to 32MB and maxssiz_64bit is now 32MB; I suggest 64MB.
Now for your real killer. You have set bufpages
at 734003 pages or ~ 2.9GB; if this is a 11.0 box then I suggest that you reduce buffer cache
to no more than about 800MB and you will probably find that 400MB is better still. If you are running 11.11 then 1GB (but no more) will probably be a good value.
You could also choose to enable dynamic buffer cache by setting dbc_max_pct to about 5-10% and dbc_min_pct to about 3% (and setting bufpages to 0) but I find that on 11.0 boxes
static buffer caches tend to perform better but on 11.11 dynamic and well-tuned static buffer caches are comparable.
If you are running raw volumes or the OnlineJFS equivalent mount options (convosync=direct,mincache=direct) then you can really reduce your buffer cache because much of it is going unused.
You really need to work with your DBA's and tell them how much memory you have and let them tell you how large an SGA they are looking at.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2002 10:05 PM
тАО09-09-2002 10:05 PM
Re: Kernel Tuning for Oracle
do mind
indicating to what extend the answers have been helpful
by
assigning points?
appreciate your effort,
thx, Tom.