- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- measure network performance and latency Oracle RAC
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-28-2009 07:23 PM
тАО09-28-2009 07:23 PM
measure network performance and latency Oracle RAC
does anybody knows how to measure network latency/performance in Oracle RAC environment between nodes/clients.
I noticed there are ORA-3136 in my alert.log which indicates network issue but I do not how to proof it.
any help appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2009 11:13 PM
тАО09-28-2009 11:13 PM
Re: measure network performance and latency Oracle RAC
Network issues are network issues.
http://www.hpux.ws/?p=6
There is an HP-UX performance gathering script.
If there is a network issue, you will spot it.
The tool runs background and does not use much resources.
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
тАО09-29-2009 03:28 AM
тАО09-29-2009 03:28 AM
Re: measure network performance and latency Oracle RAC
the link doesn't work
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2009 01:00 AM
тАО09-30-2009 01:00 AM
Re: measure network performance and latency Oracle RAC
Unix operates with beer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2009 06:16 PM
тАО10-04-2009 06:16 PM
Re: measure network performance and latency Oracle RAC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2009 07:28 PM
тАО10-04-2009 07:28 PM
Re: measure network performance and latency Oracle RAC
Did you start with a Google for "ora-3136" ?
You'll quickly stumble into lots of topics on the matter such as:
http://forums.oracle.com/forums/thread.jspa?messageID=1612957&tstart=0
Which amongst other reads:
"WHEN this error occurs in a DATAGUARD environment, normally you don't have to worry about it. It happens, when connection between primary and standby side is lost temporarily or not yet established. Of course it should not happen too often."
I suspect this is not a performance issue per-se but more and up/down, process there/process gone kind of situation. Not measured in milliseconds or packets per second but in on/off events.
And even if further investigation starts to point to raw performance after all then with all due respect to SEP, those system counters aren't going to tell you much to begin with.
Sure they are useful to get an impression of what the system is dealing with but if you really want to know what is troubling Oracle, then you should ask Oracle what seems to be the problem.
You HAVE to approach this from the Oracle angle first and seek confirmation from system stats as seems useful.
Check out ADDM, AWR, STATSPACK.
Look for RAC counters like ""GCS CR BLOCKS RECEIVED" and "GCS CR BLOCK RECEIVE TIME" and many more in GV$SYSSTATS.
Read documents like (just one of many)
http://www.oracle.com/education/america_eblasts/fy09/q1/rac_tipsandbestpractices.pdf
good luck.
Hein van den Heuvel
HvdH Performance Consulting