Monthly Archives: August 2017

Oracle OpenWorld 2017 – Time to plan your schedule

  There’s only a month to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts, which begins on October 1st in San Francisco. Of course the database development groups will be there and you will … Continue reading

Posted in OOW | Leave a comment

Controlling where objects are populated into memory on RAC

Last week I spent some time beta testing Oracle Database 12c RAC on docker (more on this in a future post) and decided to take a trip down memory lane and play around with Oracle Database In-Memory. One of the … Continue reading

Posted in Database In-Memory, Oracle Database 12c New Features | Tagged , | Leave a comment

Using DBMS_XPLAN.DISPLAY_CURSOR to examine Execution Plans

In last week’s post I described how to use SQL Monitor to determine what is happening during the execution of long running SQL statements. Shortly after the post went up, I got some requests on both social media and via … Continue reading

Posted in Optimizer, Syntax | Tagged , , , | 6 Comments

Getting the most out of Oracle SQL Monitor

I’m often asked what is the best tool for viewing execution plans and for me the answer is always SQL Monitor (included in the Oracle Tuning Pack). It really is the most invaluable tool if you need to determine what … Continue reading

Posted in Optimizer | Tagged , , , , | 4 Comments