Profile cover photo
Profile photo
Maria Colgan (SQLMaria)
Revolutionize Data Management by Adopting Transformational Technologies
Revolutionize Data Management by Adopting Transformational Technologies


Post has attachment
Does the Explain Plan command really show the execution plan that will be used? #beginners #ExecutionPlans #optimizer

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 impact on whether or not the plan we are looking at is…

Post has attachment
Oracle Autonomous Database #Autonomous #DBA #OOW

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…

Post has attachment
Are you interested in the changing face of the Oracle Optimizer?
Would you like to attend a deep dive Optimizer workshop?
Well now you can, because I'll be hosting a 1 day workshop as part of the upcoming East Coast Oracle User Group Conference in the Hilton North Raleigh/Midtown Hotel in Raleigh, NC on November 7 – 8.
You can save $25 on registration use code SQLMARIA at

Post has attachment
Day 3 of Oracle OpenWorld 2017 #IoT #OOW

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 be talking…

Post has attachment
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…

Post has attachment
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…

Post has attachment
Harnessing the Power of Optimizer Hints #Hints #optimizer #top_tip

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 of optimizer…

Post has attachment
  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…

Post has attachment
Controlling where objects are populated into memory on RAC #In-Memory #OracleDatabase12c

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 things I looked at was the new FOR SERVICE…

Post has attachment
Using DBMS_XPLAN.DISPLAY_CURSOR to examine Execution Plans #Database #DBMS_XPLAN #optimizer #top_tip

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 the blog comments asking, “If it is…
Wait while more posts are being loaded