Oracle OpenWorld Unconference Session

Session Title: Listening In: Passive Capture and Analysis of Oracle Network Traffic
Time : TBD
Date : TBD
Location : Moscone West 3rd Floor Overlooks
Room TBD


For the first time ever at Oracle OpenWorld (or any other major enterprise software industry conference), attendees will have the opportunity to directly participate by presenting their own session or workshop on a topic they're passionate about, in an informal, interactive setting.

Session Description: (insert session description)
This session is intended to discuss and demonstrate the methods for passively capturing, analyzing, and reporting the details of Oracle network traffic in real-time for use in end-to-end Oracle tuning and troubleshooting scenarios.

In cases where very short response time requirements must be met, or where sporadic spikes in response time occur, the most reliable way to tune and troubleshoot them is by capturing Oracle's Ethernet traffic, analyzing it, and reporting on various aspects of it. Throughout this session I would demonstrate the passive capture of SQL statements, their frequency, time spent in execution, number of roundtrips, and all relevant response times.

Using the data from these reports can not only assist DBAs in diagnosing network-related issues and in tuning Oracle's network settings, but also ensure that application developers are writing performant, network-friendly database access code.

This session was also submitted to OOW. If you'd like to see it there, vote for it on Oracle Mix!

Related OpenWorld Content:
Don't know of any.