Author Archives: Maria Colgan

SQL Tuning Workshop

Posted on February 19, 2020 by Maria Colgan

Last week I had the pleasure of delivering a five-part SQL Tuning Workshop for my local Oracle User Group –  Northern California Oracle User Group. The workshop explains the fundamentals of the cost-based optimizer, the statistics that feed it, the … Continue reading →

Posted in Beginners, Events, Optimizer, Oracle Database 12c New Features, Oracle Database 18c, Oracle Database 19c, Partititoning, SQL Plan Management, SQLDev, Top_Tip | Tagged , , , | 2 Comments

How do I scale an Autonomous Database?

Posted on October 22, 2019 by Maria Colgan

Traditionally database deployments have been designed and provision for the peak possible workload. And in reality, a substantial margin of safety was also provisioned on top of that in order to make sure the system could cope with any unforeseen … Continue reading →

Posted in Autonomous Database, Top_Tip | Tagged , , , | Leave a comment

OpenWorld 2019 Wrap Up

Posted on October 7, 2019 by Maria Colgan

I can’t believe Oracle Open World is done for another year. But what a great conference it was for those interested in the Oracle Database. We saw the introduction of Oracle Database 20c and of course the continuing evolution of … Continue reading →

Posted in Events, OOW | Tagged , , | Leave a comment

FREE Oracle Autonomous Database

Posted on September 16, 2019 by Maria Colgan

Today was the first day of Oracle Open World and during Larry Ellison’s afternoon keynote he made a number of extremely exciting announcements around Oracle Autonomous Database including the launch of an Always Free Tier for Developers and students in … Continue reading →

Posted in Autonomous Database, OOW | Tagged , | Leave a comment

Are you ready for Oracle OpenWorld 2019?

Posted on September 9, 2019 by Maria Colgan

With less than a week to go until Oracle Open World kicks off, I thought I would share with you what you can expect. Of course the whole Database team will be there and you will have multiple opportunities to … Continue reading →

Posted in Autonomous Database, Events, OOW | Tagged | Leave a comment

Can I use an Autonomous Database to develop new applications?

Posted on June 24, 2019 by Maria Colgan

Yes, Oracle Autonomous Database (ADB) is the ideal platform for new application development. With this family of cloud services, developers no longer have to wait on others to provision hardware, install software, and create a database for them. With ADB, … Continue reading →

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

Cloning an Oracle Autonomous Database

Posted on May 7, 2019 by Maria Colgan

Often times development and testing teams need a copy of a production database in order to develop or test using a representative dataset. Up until now, creating these cloned  environments has been a challenging and time consuming process for DBAs. … Continue reading →

Posted in Autonomous Database | Tagged , | Leave a comment

Oracle Database 19c is now available!

Posted on February 13, 2019 by Maria Colgan

Today, April 25th, Oracle Database 19c became available to downloaded from Oracle.com. Oracle Database 19c is the final member of the 12.2 family a.k.a 12.2.0.3 and is therefore the ‘long term support’ release. This means it will come with 4 … Continue reading →

Posted in New Features, Oracle Database 19c | Tagged , , | Leave a comment

Oracle RAC on Docker just got simplier

Posted on December 6, 2018 by Maria Colgan

Early this year, I wrote a blog to let you know that Oracle Database RAC was available on Docker.  However, in that blog I described a number of manual steps that were required to rebuild the image before you could … Continue reading →

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

Oracle Open World Wrap Up

Posted on November 14, 2018 by Maria Colgan

Oracle Open World this year was a crazy busy week catching up with customers, Oracle Aces, Development Champions and partners as we all crammed into the Moscone center to hear the very latest on Oracle Technologies. For the database, this … Continue reading →

Posted in Autonomous Database | Tagged | Leave a comment