Category Archives: 11g Database

RMOUG – Graham Wood 25+ years at Oracle

Posted on February 15, 2012 by mswing

Graham’s presentation on the “Hidden” Features of the Oracle Database: Since, these presentations aren’t generally published, I took notes, not guaranteed to be correct. Graham Wood Hidden Features Free Features dbms_monitor.session_trace_enable  10g plan_stat   11g argument added to dbms_monitor.session_trace_enable  dump plan … Continue reading →

Posted in 11g Database, Oracle User Groups | Comments Off

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

Meetings with Gustavo and Max at Oracle

Posted on November 1, 2011 by mswing

The two Senior Development Managers I met this morning were Max and Gustavo.  We talked about 12.1.3, 12.2, Fusion Applications and Fusion Middleware. This is  my recollection of our discussion. First, topics from 12.1.3: OATM – TruTek suggests that OATM be … Continue reading →

Posted in 11g Database, Dead Connection Detection, E Business Suite, Fusion, Fusion Applications, Middleware, Parallel Concurrent Processing and Failover, R12.1 Upgrade | 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