Symposium 2011 Speaker Spotlight - Andrey Nikolaev

Presentation Title: Contemporary Latch Internals

Presentation Abstract:

Latches in Oracle Database were radically changed during the last 10 years to achieve higher levels of concurrency and performance. Using oradebug and DTrace, this presentation explores how the latch works. Contemporary latch does not use exponential backoff, most of them spin 10 times more then expected, and they may wait for an infinite time in a queue.

This presentation will show how Oracle instruments the latch operations, discuss parameters and statistics related to latch performance diagnostics, and fine grain tuning. It will also explore the long-standing question: when and how to tune the "_spin_count" and "_latch_classes". DTrace provides additional capabilities to measure effectiveness and statistical properties of latch in production.

Presenter Bio: Andrey Nikolaev was first met with Oracle 5 in 1988. Since that time his professional interests have evolved from high performance particle physics computing, through application development, to database performance consulting, but always stay centered on performance. Working in RDTEX, Russian First Line Support company, he devotes his time to tuning and diagnosing the largest Oracle databases in Russia. As an Oracle University trainer, Andrey taught the full spectrum of Oracle database administration courses.

To find out about other speakers presenting at Hotsos Symposium 2011, please visit: www.hotsos.com.

To register for Sym and Training Day, please visit: Registration. Hope to see you there!

Hotsos Symposium 2011 Speaker Schedule Is Ready!

Hotsos is pleased to announce that the schedule of presentations is ready for your review. You can start thinking about which sessions you want to attend during the appropriate time slots.

The schedule is as follows:

• Monday, March 7, 2011


• Tuesday, March 8, 2011


• Wednesday, March 9, 2011

Don't forget about the optional Training Day with Karen Morton on Thursday, March 10, 2011. You won't want to miss a minute!

If you haven't signed up yet, please keep in mind that we restrict the size of the audience. Register today!

Profiler 5.2.5.1 Released

Hotsos is pleased to announce that Profiler 5.2.5.1 was released today.

It includes the following fixes:

• Corrected an issue with drag and drop of files from the lower pane to the upper pane.


• Corrected highlighting of literal values in long SQL text.


• Corrected bind value placeholder listing from long SQL text.


• Fixed a bug appearing in 5.2.1 that causes the Profiler kernel to improperly attribute unaccounted-for time for database calls with 'SQL*Net message to client' syscalls associated with them.

Existing customers on maintenance may download the new release from portal.hotsos.com.

All other inquiries should be sent to sales@hotsos.com or call +1.817.488.6200.

Hotsos Symposium 2011 Speaker Showcase - Alex Gorbachev

Presentation Title: Database I/O Performance: Measuring and Planning

Presentation Abstract:

As data volumes are growing exponentially these days, databases need to process more and more data in shorter amounts of time. Many disruptive technologies have also emerged such as flash-based storage, large server memory footprint, InfiniBand, etc. In such a rapidly changing environment, storage I/O performance tuning and planning easily becomes the task of applying best practices and "black magic" rules. In order to adopt a more sound, scientific approach to I/O performance diagnostics and planning, one needs to master the foundation - measuring I/O performance. This is exactly the focus of this presentation - practical I/O performance measurement and planning.

Presenter Bio: Few DBAs are as well equipped as Alex to handle any kind of database scenario. Alex has architected and designed numerous successful database solutions addressing challenging business requirements. Alex is a respected figure in the Oracle world and a sought-after leader and speaker at Oracle conferences around the globe. He regularly publishes articles on the Pythian blog and runs online webinars. Alex is a member of OakTable Network and an Oracle ACE Director.

Alex is working at The Pythian Group. He started at Pythian in Ottawa, leading a team of database experts before moving to Australia to embrace the challenges of setting up company business in the East Asia/Pacific region. Now he's back in Ottawa as Pythian's Chief Technology Officer, continuing to bridge the gap between business and technology. The search for the perfect fit between technology, engineering talents and business processes is what keeps him up at night.

Before joining Pythian, Alex developed and administered Oracle databases and applications for Lukoil, the Russian petrochemicals giant. Later, he led design and implementation of high-availability mission-critical databases for Amadeus in Germany, the leading Global Distribution System and biggest processor of travel bookings in the world.

To find out about other speakers coming to Hotsos Symposium 2011, please visit: www.hotsos.com.

To register for Sym/Training Day, please visit: Symposium Registration. Hope to see you there!

Hotsos Symposium 2011 Early Registration Ends Today

Tomorrow, the price goes up for Hotsos Symposium 2011 registration. Why don't you register today? You don't want to miss seeing Kerry Osborne, Karen Morton, Cary Millsap, Tom Kyte and many others...do you? Here's the link to register: http://www.hotsos.com/sym11/sym_reg.html.

Happy Holidays from Hotsos

There's one more shopping day until Christmas and eight more days until discounted registration ends for Hotsos Symposium 2011. Come to think of it, what a great present registration for Sym '11 would make for the one(s) you love? Sign up today!

In the meantime, happy holidays from the Hotsos crew!

Oracle Application Express Training through Sumneva

Are you interested in Oracle Application Express training? Hotsos has partnered with Sumneva to offer classes in Introduction to Oracle APEX I and II, APEX Installation and Administration, APEX v4.0 New Features, and Troubleshooting and Debugging APEX. Visit our calendar at http://www.hotsos.com/calendar.html to find out when these classes are being offered.