Oracle 18c – A New Oracle Database | Introduction

Oracle 18c – Introduction

Oracle has released Oracle 18c recently for Linux as well as Windows operating systems.

It can be installed on-premises or in Oracle Cloud (private/public).

Oracle Database 18c is an autonomous database that contains the world’s fastest and reliable database technology catering to businesses ranging from small-scale industries to large conglomerates.

It is a secure, cost-effective, scalable and reliable database technology.

Why the name is Oracle 18c?

Oracle 18c follows the yearly release nomenclature. It is the first release of Oracle to do so.

18c is Oracle Database Release 2 12.2.0.2 and 18 in the name is a year of the product release.

Don’t worry you haven’t missed versions from Oracle 13c to Oracle 17c.

What you can expect in Oracle 18c?

The three important features of Oracle 18c are

  • Multitenant Database Architecture
  • In-Memory Database
  • Oracle Database Sharding

Multitenant Database Architecture

The multitenant database architecture enables the database to be a CDB (container database).

A single container database hosts one or more pluggable databases (PDB).

Benefits of multitenant database architecture

  • Only a single physical database is consumed in multitenant database architecture.
  • Cost reduction of hardware due to the installation of a physical database on a single disk
  • Rapid data and code migration
  • Easy monitoring and maintenance of the database
  • Faster database upgrade by plugging and unplugging in PDBs
  • Ability to set performance limits for memory and Input/Output at PDB level
  • Prevents loss of data as data is separated across multiple pluggable databases (PDBs)

In-Memory Database

In-memory database features include the In-memory column store, advanced query optimizations, and availability solutions.

The in-memory database comprises of tables represented as rows in the memory using conventional raw format and new in-memory column format.

It is beneficial for real-time analytics due to speedy scans to fetch data faster.

This feature is easy to implement and requires no changes in the application.

Oracle Database Sharding

In Oracle Database Sharding, data is horizontally partitioned across independent databases.

This architecture comprises each database having a dedicated server with its own CPU, memory, flash or stick.

Multiple such databases form a single logical database together.

The horizontal partitioning enables database split across shards that contain a table with same columns but a different set of rows.

A fault in one shard does not affect others as each of them possesses dedicated logical resources.

The main benefit of Oracle Sharding lies in the higher scalability of the database along with RDMS capabilities of Oracle database.

Please feel free to write us at connect@oraclemine.com or hioraclemine@gmail.com if you find mistakes or errors in any of the topics. Your suggestions to improve article helps us improve.

You can also Subscribe here to stay updated on the latest posts of OracleMine.com.

Hi I am Paras.

Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine@gmail.com. Again I appreciate your visit. Hope to see you again and again!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.