Author Archives: Maria Colgan

Getting started with Oracle Autonomous Transaction Processing

Posted on August 21, 2018 by Maria Colgan

Getting started with Oracle Autonomous Transaction Processing is actually much easier than you might think. In fact, with Oracle’s $300 in free cloud credits you can probably get your first 30 days on the service for free. Please note, you … Continue reading →

Posted in Autonomous Database, Beginners, Oracle Database 18c, Top_Tip | Tagged , , , | Leave a comment

What you can expect from Oracle Autonomous Transaction Processing

Posted on August 7, 2018 by Maria Colgan

Today Larry Ellison announced the general availability of Oracle Autonomous Transaction Processing (ATP), the newest member of the Oracle Autonomous Database family, combining the flexibility of cloud with the power of machine learning to deliver data management as a service. … Continue reading →

Posted in Autonomous Database, Exadata, Oracle Database 18c | Tagged , , | 1 Comment

How does Autonomous Transaction Processing differ from the Autonomous Data Warehouse?

Posted on August 7, 2018 by Maria Colgan

In my previous post, I explained that  Oracle Autonomous Transaction Processing has three main attribute: Self-Driving, Self-Securing and Self-Repairing. All of the functionality I described in that post is shared between both the Autonomous Data Warehouse (ADW) and ATP. Where … Continue reading →

Posted in Autonomous Database, Oracle Database 18c | Tagged , , , | 1 Comment

Oracle Launches TimesTen Scaleout!

Posted on July 25, 2018 by Maria Colgan

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!

Posted on July 23, 2018 by Maria Colgan

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

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

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