- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g and turning off/on hyperthreading while...
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
тАО10-22-2010 01:17 PM
тАО10-22-2010 01:17 PM
Re: Oracle 10g and turning off/on hyperthreading while db is up
When you do both of these, and you're running a test, you'll notice cpu a bit higher, but keep in mind that that cpu is going to run higher because it *can*! If your processes aren't waiting as much on I/O, and not waiting as much on latches for block buffers, yes, you can and will use more cpu, however, our number of transactions completed during the test went up as well! Meaning that our tests, when running them transaction count based, finished faster, or if we ran them for x amount of minutes, the amount of transactions completed in that same time increased. Meaning that the server is just way more responsive queries. Just don't freak out when you make those two move and you cpu load increase, it is only increasing because it *can* do more work in the same amount of time!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-24-2010 11:53 AM
тАО10-24-2010 11:53 AM
Re: Oracle 10g and turning off/on hyperthreading while db is up
Great that you are using CIO, however I think you should review Oracle Support Doc ID ID 1231869.1
Specifically:
-------------------------
Do not use "-o cio" and "-o mincache=direct,convosync=direct" together. Use either Direct I/O or Concurrent I/O.
Using Direct I/O and Concurrent I/O("-o mincache=direct,convosync=direct,cio") may cause performance regression.
-------------------------
And:
-------------------------
Placing Oracle binaries ($ORACLE_BASE directory) on a filesystem mounted with "cio" may cause data loss and other unexpected problems.
-------------------------
And Finally:
-------------------------
Concurrent IO is not expected to provide a performance benefit over direct IO when used with online and archived redo logs.
-------------------------
So:
- use none of cio,mincahce=direct,convosync=direct on Oracle binares
- use cio on datafiles
- use mincahce=direct,convosync=direct on online/archive redo logs
That said, I don't always trust Oracle support documents when it comes to HP-UX (e.g. I'm pretty sure that article 555601.1 is just plain wrong when it comes to the flags you see for direct IO on HP-UX), so you might want to test these assertions...
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-25-2010 05:13 AM
тАО10-25-2010 05:13 AM
Re: Oracle 10g and turning off/on hyperthreading while db is up
I'm going to look into that. However, the notes I had were that we should be using cio and direct i/o together. I plan to research that note asap however, and ask for feedback from our performance specialists.
If I had to lose one or the other, I'd lose cio. We did test them separately (direct i/o and cio), and the big bang for our buck was direct i/o. However, while we did see increased cpu costs for cio, we also saw increased throughput on the testing model. We figured the increased cpu cost was for doing more processing per unit of time, because we could, after clearing the waits after writes in I/O. You know how it goes, you clear one bottleneck to move onto the next.
Fortunately/unfortunately (that is, happily)- I'm live with both this morning. But, I will definitely investigate and pass this information on with the HPUX/Oracle performance team at HP which I procured for this conversion.
And no, binaries, report output, etc. are not mounted either cio or direct i/o.
I appreciate the thoughtfulness for the posting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-03-2010 08:42 PM
тАО11-03-2010 08:42 PM
Re: Oracle 10g and turning off/on hyperthreading while db is up
For anyone seriously interested in Hyper Threading under HP-UX there is a MUST READ (watch/listen) session in the Knowledge On Demand presentations.
All presentations:
http://h71028.www7.hp.com/enterprise/w1/en/os/hpux11i-kod-overview.html
HT session is: Hyper-Threading on HP-UX 11i v3
The flash version did not work for me.
TheZIP file worked:
http://downloads.hpmediasolutions.com.edgesuite.net/managed/19031-1-MontecitoHyperThreadingOnHpUx11iV3_WindowsMedia.zip
The slides alone (PDF) work fine also.
The part I thought was interesting were
- slide 27: "Time Accounting on Montecito"
One key word in the is "hint@pause" which is something OpenVMS also uses.
- slide 31: "OS Scheduler change"
- slide 34: 1) Just try it! 2) probably need 75% cpu load while non-HT, 3) Potential for more throughput, not for better response time.
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2010 05:34 AM
тАО11-05-2010 05:34 AM
Re: Oracle 10g and turning off/on hyperthreading while db is up
What we've found here is that hyperthreading is absolutely wonderful for our big, nasty largely untuned or not-tuned-enough code that runs at night, along with lot's of maintenance code which includes, lots of accounting stuff, gathering statistics, checking index depths, updating and checking data growth, generating price books, bom trees, etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2010 05:40 AM
тАО11-05-2010 05:40 AM
Re: Oracle 10g and turning off/on hyperthreading while db is up
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-05-2010 07:27 AM
тАО11-05-2010 07:27 AM
Re: Oracle 10g and turning off/on hyperthreading while db is up
;^))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2010 12:42 PM
тАО12-06-2010 12:42 PM
Re: Oracle 10g and turning off/on hyperthreading while db is up
I turned on HT and my systems are now able to run more of our home grown perl and C short term exececution (but zillions of them) apps.
- « Previous
- Next »