Author Archives: Maria Colgan

Does the Explain Plan command really show the execution plan that will be used?

When it comes to SQL tuning we often need to look at the execution plan for a SQL statement to determine where the majority of the time is spent. But how we generate that execution plan can have a big … Continue reading

Posted in Beginners, Optimizer | Tagged , , , | Leave a comment

Oracle Autonomous Database – What you need to know

At OpenWorld, Larry Ellison announced  an Autonomous Database cloud (service), which is self-driving, self-securing, and self-repairing. Although there was a lot of excitement surrounding the announcement, there were also a lot of questions. How does it work exactly? When and where … Continue reading

Posted in Autonomous Database, OOW | Tagged , , | 3 Comments

Oracle Open World 2017 Wrap Up!

Thanks to all the customers, Oracle Aces, Development Champions and partners that made this year’s Open World an amazing event! The conference was four, jam-packed days of great technical sessions and interesting discussions especially around the new Autonomous Database. I was … Continue reading

Posted in OOW | Tagged | Leave a comment

Day 4 of Oracle Open World 2017

It’s the last day of Oracle OpenWorld and we have saved the very best for last. So hopefully you are still awake and functioning at this stage! You can start the day off at 12 noon in Moscone West, room … Continue reading

Posted in Events, OOW | Tagged | 2 Comments

Day 3 of Oracle OpenWorld 2017

Hopefully you enjoyed yesterday, the second full day of technical sessions at Oracle OpenWorld and are ready for more today! At 11:30 am today I give my first technical session, with the wonder Dominic Giles of Swingbench fame! Dom and I will … Continue reading

Posted in Events, OOW | Tagged , | Leave a comment

Day 2 of Oracle Open World 2017

Oracle OpenWorld started yesterday and San Francisco is just buzzing with Oracle folks and the excitement generated by the new Oracle Autonomous Database announcements made by Larry Ellison during last night’s keynote! If you are interested in more information on the Autonomous Database … Continue reading

Posted in AskTom, Events, OOW | Tagged | Leave a comment

Day 1 of Oracle OpenWorld 2017

The biggest day of the Oracle calendar has arrived. Oracle OpenWorld 2017 officially starts today! The show kicks off with ton’s of great technical sessions selected by the Oracle User Groups including several great sessions on Oracle Database 12c, Data Management … Continue reading

Posted in Events, OOW | Tagged | Leave a comment

Harnessing the Power of Optimizer Hints

Last week I was lucky enough to have participated in the Trivadis Performance Days 2017 conference and several people have asked if I would share the slides from one of my sessions. The session in question was called “Harnessing the power … Continue reading

Posted in Optimizer | Tagged , , | Leave a comment

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