Author Archives: Maria Colgan

JEFF Talks From Kscope18

Posted on June 12, 2018 by Maria Colgan

The first day of the ODTUG Kscope conference is always symposium Sunday. This year’s Database symposium, organized by @ThatJeffSmith, consisted of multiple, short, rapid  sessions, covering a wide variety of database and database tool topics, similar to Ted Talks but … Continue reading →

Posted in Beginners, Events, JSON, Syntax, Top_Tip | Tagged , , , , | Leave a comment

Avoiding reparsing SQL queries due to partition level DDLs – Part 2

Posted on June 6, 2018 by Maria Colgan

In my pervious post, I promised to provide an alternative solution to avoiding repasing SQL queries due to partition level DDLs. So, what is it? In Oracle Database 12 Release 2 we implementing a fine-grained cursor invalidation mechanism, so that … Continue reading →

Posted in IoT, Partititoning, Top_Tip | Tagged , , | 1 Comment

Avoiding reparsing SQL queries due to partition level DDLs – Part 1

Posted on June 6, 2018 by Maria Colgan

A couple of weeks ago, I published a blog post that said specifying a partition name in the FROM clause of a query would prevent an existing cursor from being hard parsed when a partition is dropped from the same … Continue reading →

Posted in IoT, Partititoning, Top_Tip | Tagged , , | Leave a comment

Automatic Collection of Fixed Objects Statistics in 12c

Posted on April 17, 2018 by Maria Colgan

In my previous life as the Optimizer Lady, I wrote a blog on the importance of gathering fixed object statistics, since they were not originally gathered as part of the automatic statistics gather task. Starting with Oracle Database 12c Release … Continue reading →

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

Should you gather System Statistics?

Posted on April 10, 2018 by Maria Colgan

While at the HotSOS Symposium, last month, I caused quite a stir when I recommended that folks should never gather system statistics. Why such a stir? It turns out this goes against what we recommend in the Oracle SQL Tuning … Continue reading →

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

Oracle RAC now available on Docker!

Posted on March 29, 2018 by Maria Colgan

I began my love affair with Docker a year ago when @GeraldVenzl got me started with my very first 12.2 Multitenant container database on Docker and I have to say I absolutely love the convenience of having an Oracle Database … Continue reading →

Posted in Docker, RAC | Tagged , , | Leave a comment

How to determine which view to use

Posted on March 13, 2018 by Maria Colgan

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

Can GPUs speed up Database workloads?

Posted on March 1, 2018 by Maria Colgan

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 , , , | 1 Comment

Oracle OpenWorld 2018 Call for papers is open!

Posted on February 27, 2018 by Maria Colgan

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

Posted on February 16, 2018 by Maria Colgan

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