Author Archives: Maria Colgan

Oracle Launches TimesTen Scaleout!

What a week for announcements! First we had Oracle Database 18c available on-premises and now Oracle TimesTen Scaleout. If you are not familiar with TimesTen, let me reminder you that it’s Oracle’s  In-Memory Database. In fact, it’s been a leading … Continue reading

Posted in Database In-Memory, New Features, Uncategorized | Tagged , | Leave a comment

Oracle Database 18c is now available for Download!

Today Oracle officially released Oracle Database 18c for download on Linux x86-64. As you may recall, we originally released 18c on the Oracle Public Cloud and Oracle Engineered Systems back in February. So, when will you be able to get … Continue reading

Posted in New Features, Oracle Database 18c | Tagged , , | 2 Comments

JEFF Talks From Kscope18

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

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

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

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

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

Should you gather System Statistics?

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

Oracle RAC now available on Docker!

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

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?

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