Author Archives: Maria Colgan

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 , , , , | 3 Comments

Overriding DBMS_STATS Parameter Settings

Since it’s introduction in Oracle Database 8i, the DBMS_STATS package is Oracle’s preferred method for gathering statistics. With each new database release the DBMS_STATS package is extended to accommodate new approaches to gather statistics and new types of statistics. Over … Continue reading

Posted in New Features, Optimizer, Oracle Database 12c New Features | Tagged , , | Leave a comment

Oracle Database 12c and DevOps

Over the last month or so I’ve been on the road presenting at different user group conferences and meeting with customers. I’ve gotten a number of requests via blog comments to share the slides for the sessions I presented. One … Continue reading

Posted in Docker, Multitenant, New Features, Oracle Database 12c New Features | Tagged , , , , , | Leave a comment

40 years of Database innovations

June 16th 2017 marks the 40th anniversary of the founding of Oracle, which actually began life as Software Development Laboratories. Larry Ellison, Bob Miner, and Ed Oates set out to build the worlds best relational database and what an amazing 40 … Continue reading

Posted in Events | Tagged , | Leave a comment

Upcoming Events

The month of June is shaping up to be jam packed with great Oracle conference all across the global and I’m fortunate enough to have the opportunity participate in 3 of them  and hope to catch up with a lot of folks … Continue reading

Posted in Events | Tagged | 2 Comments

Oracle Database Audio White Papers

Back in April, I shared with you a new white paper that described a set of best practices or management techniques to facilitate IoT workloads with the Oracle Database. Since then there have been a number of updates in this space that I … Continue reading

Posted in IoT, technical_papers, Whitepapers | Tagged , | Leave a comment

Extremely useful Partitioning enhancements in Oracle Database 12c

Back in January, I promised I would write a series of blogs on some of my favorite new 12c enhancements, designed to make your life easier. I’m finally getting around to keeping that promise with this weeks blog post on my … Continue reading

Posted in Oracle Database 12c New Features, Partititoning, Syntax | Tagged , | 2 Comments

Optimizer Histograms

At the recent OUG Ireland conference I had the privilege of participating in a panel discussion on the Oracle Database. During the course of the session the topic of Optimizer histograms came up. As always, a heated discussion ensued among … Continue reading

Posted in Optimizer, Statistics, Syntax | Tagged , , | 9 Comments

Upcoming Event: Georgia Oracle Users Group Tech Days 2017

I’m delighted to have been given an opportunity to deliver the keynote session  at this year’s Georgia Oracle Users Group Tech Days 2017. The conference takes place on  May 9-10, 2017, at the Loudermilk Conference Center in Atlanta, Georgia and is shaping … Continue reading

Posted in Events, Oracle Database 12c New Features | Tagged , | Leave a comment