Database Management Simplified

Ross Group Inc  MemberzPlus  Blogs  |  News  |  Careers  |  Contact    Twitter CommitDBA LinkedIn CommitDBA

CommitDBA Blogs

See What we are Talking About!

CommitDBA Blog

Steve Woody, Senior VP Ross Group Inc

Takeaway #2 from Oracle OpenWorld 2016 - Oracle 12cR2 Release

Steve Woody, CommitDBA President

October 20, 2016

Oracle OpenWorld 2016 (OOW16) was held in San Francisco from September 18th through the 22nd with a reported 50K+ attendees. The conference featured more than 2,500 sessions and 3,000 speakers. As President of CommitDBA services, I focused in all platforms surrounding the Oracle 12c database stack and Oracle cloud platform. This blog along with nine other blogs presents ten important and key takeaways from Oracle OpenWorld 2016.

Oracle confirmed that the much anticipated database release 12.2 (12cR2) will be Oracle cloud-only available for at least the first six months. While frustrating to some since there are many new features embedded in the 12cR2 release, Oracle’s reasoning is that any major flaws and bugs will be flushed out in the cloud before the on-premise release is available - therefore making the on-premise release very stable. Others think that this is Oracle’s way of encouraging and incentivizing customers to migrate to Oracle cloud. My view on this is that both reasons are somewhat valid regarding their tactics for the Oracle 12cR2 release.

Oracle 12cR2 Release Enhancements and Features

There are many new features, enhancements, fixes and other attributes with the 12.2 release. Listed below are just a few new important features.

Online Conversion of a Non-partitioned Table to a Partitioned Table

Non-partitioned tables can be converted to partitioned tables online now. Indexes are maintained as part of this operation and can be partitioned as well. The conversion has no impact on the ongoing DML operations. The online conversion of a non-partitioned table to a partitioned table enables any application to adopt partitioning without application downtime. Customers can adopt partitioning for any system and evolve tables as needed to benefit from the partitioning for large tables.

Advanced Index Compression

Prior to the 12cR2 release, the only form of advanced index compression was low compression. Now you can also specify high compression. High compression provides even more space savings than low compression. Indexes consume a large amount of storage within many databases. The high level of advanced index compression provides significant space savings while also improving performance for queries that are executed using indexes

Pluggable Databases

Prior to the 12cR2 release, the restriction for the number of Oracle Multitenant Pluggable Databases per instance was 252. With the new release, that number has increased to 4096 providing even more architectural service and maintenance advantages that Multitenant Oracle includes when combining multiple databases under one instance.

Look for more Oracle cloud features and articles coming out soon on the CommitDBA blog site.

For additional information on CommitDBA, please contact us at 844.220.4272.

Got database support needs?
Professional and Affordable DBA and Data Services

Contact us Today