- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle benchmarking
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-17-2008 09:40 AM
тАО03-17-2008 09:40 AM
Thanks,
Allan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 09:49 AM
тАО03-17-2008 09:49 AM
SolutionBenchmark your application? In that case you need a dedicated driver. You may want to use a tool like 'loadrunner' for this.
Nagios is a monitor tool, so you could use it to report on a benchmark result, not to run one.
As a starting point for oracle benchmarking you may want to google for 'swingbench'
And be sure to contact Oracle or Application documenation/FAQs/Forums for further help because this is typically NOT Hpux dependent allthough some solutions may or mighe not be available for hpux.
And... consider professional help.
Your typical 'quick & dirty' artificial benchmark is a total waste of time pinning a meaningless number ona meaningless operation.
Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 10:11 AM
тАО03-17-2008 10:11 AM
Re: Oracle benchmarking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 10:12 AM
тАО03-17-2008 10:12 AM
Re: Oracle benchmarking
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 10:18 AM
тАО03-17-2008 10:18 AM
Re: Oracle benchmarking
Can we measure the Oracle performance parameters ( thru Nagios )while doing load test . Has anybody tried that before. Please share.
Thanks,
Allan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 10:22 AM
тАО03-17-2008 10:22 AM
Re: Oracle benchmarking
what do your really need?
Have a look at Oracle Enterprise Manager Database control which comes with your oracle installation.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 10:34 AM
тАО03-17-2008 10:34 AM
Re: Oracle benchmarking
I view them more as 'production/operational support' helpers than as performance measurement tools, but will be happy to be proven wrong
For serious performance work IMHO you need to get to the source: Oracle statspack / AWR and/or Enterprise Manager.
Helpers distort.
I like using Time-Line tools to be able to correlate OS and DB stats, but mostly roll my own based on specific needs.
fwiw,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2008 08:45 PM
тАО03-17-2008 08:45 PM
Re: Oracle benchmarking
Which version of Oracle are you using?
We run oracle 10g r2 and the OEM database control allows us to view performance over an Historical Interval Selection.
The main portion allows us to analyse performance of the instance in the form of session wait, CPU and user IO.
Detailed reports over a specified interval show us:
- Host-level: Runnable processes and Load average
- Average Active sessions: Active sessions against performance indicators like (network, concurrency, user IO, system IO, CPU Used, etc)
- Instance Disk IO: per second indications of Physical writes and Physical reads
- Instance Throughput:
o Logons and transactions per second
o Physical reads and redo size
Hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-18-2008 09:31 AM
тАО03-18-2008 09:31 AM