Category Archives: Performance Tuning

Six Easy Pieces: Essentials of Database Tuning for Packaged Applications

Posted on November 6, 2011 by mswing

December 7th at 14:25, Track 1 Six Easy Pieces: Essentials of Database Tuning for Packaged Applications Packaged Applications such as E-Business Suite and Demantra may require significant hardware and performance tuning resources. Large investments in hardware will benefit from periodic … Continue reading →

Posted in Performance Tuning | Comments Off

Dead Connection Detection works in 11.1.0.7

Posted on October 8, 2011 by mswing

A couple of years ago I wrote a paper on how to adjust the TCP settings so that TNS would detect a dead connection. I also demonstrated how Oracle cleans up processes, but may leave sessions connected to the database. … Continue reading →

Posted in 11g Database, Dead Connection Detection, Performance Tuning | Tagged , , | Comments Off

Monday at Oracle Open World

Posted on October 4, 2011 by mswing

Awesome presentations including some of my favorite presenters/authors, Tim Gorman, Cary Millsap, Debra Lilley, Dennis Horton and Deep Ram, Tanel Poder, Nadia Bendjedou and Cliff Godwin. My Favorite presentation was from Cary Millsap on his presentation on “Skew”. Skew is … Continue reading →

Posted in Oracle Open World, Performance Tuning | Tagged , , | Comments Off