Faster Oracle Database Upgrades but with lesser memory

Here is a shout out to very good blog post by Mike Dietrich Master Product Manager for Oracle Database Upgrade and Migrations: Faster Oracle Database Upgrades but with lesser memory.

Quick Recap on this topic.

• Reducing SGA and PGA sizes for Database Upgrades makes the whole process faster by leveraging lesser memory.
• Leverage Large Pages for Database Operations and Upgrades.
• Database is started in Upgrade Mode during restarts.
• Upgrades don't touch User Data.

Cheers.

Converged/Consolidated Databases: A Quick Overview

What are Converged/Consolidated Databases?

Here is an excellent blog post on this topic by Maria Colgan Master Product Manager at Oracle Product Management. Here is a quick summary of the characteristics/properties of Converged/Consolidated Databases.

• Converged/Consolidated Databases 
• Converged/Consolidated Databases cater to all types of data, workloads and development protocols.
• Eliminating data fragmentation also eliminates data contagion in Converged/Consolidated Databases enabling application logic/modules to use and reuse a shared data copy across the organization.
• Converged/Consolidated Databases enable more synergy for data and workloads making development faster.
• Converged/Consolidated Databases make it much simpler for developers to run stuff like Cloud, Autonomous/ML, extended SQL, spatial, blockchain, IoT etc. in one singular consolidated database rather than running them across distributed Single-Purpose databases.
• Converged/Consolidated Databases provide native support for all modern data types and most of the latest/prevalent development protocols.
• Converged/Consolidated Databases helps the overall ecosystem to be relatively lesser complex which results in lesser maintenance and development costs in the medium to long run.
• Converged/Consolidated Databases provide more/better integration for data and workloads.
• Oracle Database is a very successful example/manifestation of a Converged/Consolidated Databases model.

This video by Juan Loaiza & Andrew Sutherland gives a good summary on this topic.

I hope you got a quick overview of Converged/Consolidated Databases in this blog post.

Cheers.

Oracle Database 20c - A Sneak Peak into whats coming

Oracle Database 20c - A Sneak Peak into whats coming.

Here is an excellent blog post by Dominic Giles Master Product Manager at Oracle summarizing a Preview of Oracle Database 20c which was refreshed to v20.3 on the Oracle Cloud DBCS Platform. Here is a quick recap on this topic.

• Oracle Database 20c is the latest upcoming version in the multi-model family of Oracle Databases.
• Oracle Database 20c focus and push is on the Converged/Consolidated Database model. Here is a quick summary about Converged/Consolidated Databases:
• Converged/Consolidated Databases cater to all types of data, workloads and development protocols.
• Eliminating data fragmentation also eliminates data contagion in Converged/Consolidated Databases enabling application logic/modules to use and reuse a shared data copy across the organization.
• Converged/Consolidated Databases enable more synergy for data and workloads making development faster.
• Converged/Consolidated Databases make it much simpler for developers to run stuff like Cloud, Autonomous/ML, extended SQL, spatial, blockchain, IoT etc. in one singular consolidated database rather than running them across distributed Single-Purpose databases.
• Converged/Consolidated Databases helps the overall ecosystem to be relatively lesser complex which results in lesser maintenance and development costs in the medium to long run.
• Some of the New Features in Oracle Database 20c
• Blockchain Tables.
• SQL Macros.
• In-Memory Enhancements:
• Self-Managing In-Memory Column Store.
• In-Memory Hybrid Columnar Scans.
• Database In-Memory Vector Joins.
• Native JSON datatype Support.
• Machine Learning for Python and AutoML.
• Optimized Graph Models.
• Sharding Enhancements/Improvements.
• Persistent Memory Support.
• Expression based init.ora parameters.
• Automatic Zone Maps.
• A whole lot more is coming with Oracle 20c: Stay Tuned...

I hope you got a quick overview of whats coming in Oracle Database 20c which was refreshed to v20.3 on the Oracle Cloud DBCS Platform.

Cheers.