Oracle Major Features Depend on Versions you are using.

Oracle 8

Oracle 8 was introduced with many features but I like few which we always use from the beginning.

  • RMAN (Recovery Manager), which is the backup and recovery tool of Oracle database.
  • Partitioning feature, which makes a great contribution to the Database management system in terms of performance.
  • Disaster Recovery feature called Dataguard is released with Oracle 8

Oracle 9

Oracle 9 most important feature which I like

Real Application Cluster (RAC) feature. Oracle RAC will help us to use multiple Oracle Instance, which is installed on multiple servers at the same time, provides high availability of databases, which we call high availability. Till yet another database has no feature like RAC (active-active).

Oracle 10g

Oracle 10g my favorite new enhancement

Automatic Storage management. The Real application Cluster feature, which comes with Oracle 9, has been improved and the Grid Infrastructure feature has also come with 10g.

Flashback feature, which is one of the most important features for database administrators and shortens the recover on user errors.

Advanced Compression: Provides a comprehensive set of compression capabilities to help improve database performance and reduce storage costs. It allows organizations to reduce their overall database storage footprint by enabling compression for all types of data: relational (table), unstructured (file), index, network, Data Guard Redo and backup data. While query performance, storage cost savings and data optimization are often seen as the most tangible benefits, additional innovative technologies can help reduce CapEx and OpEx costs for all components of an IT infrastructure, including memory and network bandwidth as well as heating, cooling and floor-space.

Transparent Data Encryption: Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. Transparent Data Encryption (TDE) ensures that sensitive data is encrypted, meets compliance, and provides functionality that streamlines encryption operations.

Oracle Data Pump: Oracle Data Pump technology enables the high-speed movement of data and metadata from one database to another. The Data Pump supports four ways to perform the loading and unloading of the data:

  • Direct path

  • External tables

  • Data file copy

  • Network link

Oracle 11g

In Oracle 11g Exadata is my most favorite enhancement which was designed as a database machine introduced by Oracle on the hardware side.

Default Passwords: Oracle Database 11g now offers a way to quickly identify users with default passwords, implemented in the rather ludicrously simple way of checking a single data dictionary view

Case-Sensitive Passwords

In Oracle Database prior to release 11g, user passwords were case insensitive.

Active data guard feature was introduced in this version for the disaster recovery feature of Dataguard databases.

Data Redaction

Hybrid Columnar Compression

Cluster File System 

Oracle 12c

Oracle has announced many different features with 12c version, it has already echoed in the market and the most important reason for this is that it announces Cloud feature. Now the concept of g (grid) in 10g and 11g has been replaced by c (cloud).

Oracle 12c’s TOP features are as follows.

  • Oracle Multitenant
  • Far Sync
  • Online Datafile move
  • Table Restore from Full Backup
  • İnvisible Column
  • Automatic  Data Optimization
  • Flex ASM
  • Data Masking
  • Multiple index for the same column

Oracle18c

Autonomous Database and Data Guard Multi-Instance Redo Apply are the most important features in this version. Let’s look at what this feature is.

Autonomous Database

Oracle Autonomous Database is a cloud-based technology introduced in 2017, designed to automate many of the routine DBA tasks required to manage Oracle databases. In particular, Oracle says that database administrators (DBAs) will have the opportunity to do higher and more strategic tasks rather than routine and tedious tasks. Because lots of DBA tasks will be done by Oracle, thus Oracle will be a self-managed database.

Autonomous Database feature is provided as a cloud service created by machine learning algorithms called self-driving, self-safety and self-repair slogans.

Oracle 19c

  • Automatic Indexing
  • Data-guard DML Redirect
  • Partitioned Hybrid Tables
  • Real-time Stats + Stats Only Queries features.

 

 

 

 

Leave a comment