Category Archives: Oracle Database 12c New Features

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

SQL Plan Management – Selective Automatic Plan Capture Now Available!

Over the years, Oracle has provided a number of techniques to help you control the execution plan for a SQL statement, such as Store Outlines and SQL Profiles but for me the only feature to truly give you plan stability … Continue reading

Posted in Optimizer, Oracle Database 12c New Features, SQL Plan Management, Uncategorized | Tagged , , , , | Leave a comment

Controlling where objects are populated into memory on RAC

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 … Continue reading

Posted in Database In-Memory, Oracle Database 12c New Features | Tagged , | Leave a comment

Overriding DBMS_STATS Parameter Settings

Since it’s introduction in Oracle Database 8i, the DBMS_STATS package is Oracle’s preferred method for gathering statistics. With each new database release the DBMS_STATS package is extended to accommodate new approaches to gather statistics and new types of statistics. Over … Continue reading

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

Oracle Database 12c and DevOps

Over the last month or so I’ve been on the road presenting at different user group conferences and meeting with customers. I’ve gotten a number of requests via blog comments to share the slides for the sessions I presented. One … Continue reading

Posted in Docker, Multitenant, New Features, Oracle Database 12c New Features | Tagged , , , , , | Leave a comment

Extremely useful Partitioning enhancements in Oracle Database 12c

Back in January, I promised I would write a series of blogs on some of my favorite new 12c enhancements, designed to make your life easier. I’m finally getting around to keeping that promise with this weeks blog post on my … Continue reading

Posted in Oracle Database 12c New Features, Partititoning, Syntax | Tagged , | 5 Comments

Upcoming Event: Georgia Oracle Users Group Tech Days 2017

I’m delighted to have been given an opportunity to deliver the keynote session  at this year’s Georgia Oracle Users Group Tech Days 2017. The conference takes place on  May 9-10, 2017, at the Loudermilk Conference Center in Atlanta, Georgia and is shaping … Continue reading

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

Oracle Database 12c now available on Docker

Last week at Dockercon, Oracle announced that the Oracle Database is now available alongside other Oracle products the on Docker Store. Given how much folks here in Silicon Valley (including my better half) rave about how easy and great Docker … Continue reading

Posted in Docker, Oracle Database 12c New Features | Tagged , | 23 Comments

New Top-N Queries and Pagination Syntax

At the RMOUG Training Days, a couple of weeks, ago @GeraldVenzl and I delivered a session demonstrating what it would take to get a REST enabled, web-based application up and running with Oracle Database 12c. During the session Gerald asked me … Continue reading

Posted in Oracle Database 12c New Features, Syntax | Tagged , | 1 Comment

What’s New With Database In-Memory in 12.2?

My favorite marquee feature in Oracle Database 12c is Database In-Memory. With the introduction of Database In-Memory in 12.1.0.2, data can now be populated into memory both in a row format (the buffer cache) and a new in-memory optimized column … Continue reading

Posted in Database In-Memory, Oracle Database 12c New Features | Tagged , | Leave a comment