Author Archives: Maria Colgan

How to determine which view to use

Often times DBAs or application architects create views to conceal complex joins or aggregations in order to help simplify the SQL queries developers need to write.  However, as an application evolves, and the number of views grow, it can often … Continue reading

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

Can GPUs speed up Database workloads?

Recently there has been a lot of interest or hope that Graphics processing units or GPUs would be able to transparently accelerate database workloads. So, I thought it was worth investigating what Oracle is up to regarding getting transparent performance … Continue reading

Posted in GPUs | Tagged , , , | Leave a comment

Oracle OpenWorld 2018 Call for papers is open!

Believe it or not, it’s time to start thinking about Oracle OpenWorld 2018! The Oracle OpenWorld 2018 call for papers is now opens! Oracle customers and partners are encouraged to submit proposals to present at this year’s Oracle OpenWorld conference, … Continue reading

Posted in Events, OOW | Tagged | Leave a comment

Oracle Database 18c Released

Today Oracle officially released Oracle Database 18c on the Oracle Public Cloud and Oracle Engineered Systems. This is the first version of the database to follow the new yearly release model and you can find more details on the release … Continue reading

Posted in Oracle Database 18c, Whitepapers | Tagged , | Leave a comment

SQL Plan Management – Selective Automatic Plan Capture Now Available!

Over the years, Oracle has provided a number of techniques to help you control the execution plan for a SQL statement, such as Store Outlines and SQL Profiles but for me the only feature to truly give you plan stability … Continue reading

Posted in Optimizer, Oracle Database 12c New Features, SQL Plan Management, Uncategorized | Tagged , , , , | Leave a comment

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 , , , | 1 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. Is Oracle Database 18c the Autonomous Database? How … 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