Data Blog

What are the New Features of Oracle Database 18c?

Oracle Database 18c is now directly integrated with Microsoft Active Directory Services.

With the release of Oracle Database 18c, you can expect new features and functionality.

Are these additional features enough for you to decide on upgrading to the latest database version from the technology giant? These features include:

Availability features of Oracle Database 18c

  1. Non-logged blocks are now automatically corrected using an Oracle Data Guard standby database.
  2. Oracle Data Guard’s MIRA (multi-instance redo apply) now supports block change tracking for RMAN.
  3. You can now create shadow table spaces to ensure that your data is protected. You will no longer use ADG to protect your data from lost write instances.
  4. If you have non-cloud database backups, you can still use it after moving to the cloud.
  5. With Oracle Database 18c, your shards and catalogs can be a PDB file.
  6. You can now specify where your data is going to be stored in a shard.
  7. If you have multi-shard queries, you can now provide consistency levels.
  8. You can now manually terminate run-away queries without having to stop the session.

 

Data warehousing and big data features

  1. Oracle 18c expands on the approximate query processing that you use in Oracle 12c.
  2. Oracle Database 18c now supports LOBs and related features & functionality when used with Big Data SQL and Oracle Database In-Memory.

 

General database features

  1. You now have two new parameters to copy a pluggable database (PDB) in Oracle Data Guard: STANDBY_PDB_SOURCE_FILE_DIRECTORY and STANDBY_PDB_SOURCE_FILE_DBLINK.
  2. You now have another PDB lockdown profile enhancement, giving you three lockdown profiles: PUBLIC_DBAAS, PRIVATE_DBAAS, and SAAS.
  3. Improved PDB refresh with switchover now being supported by 18c.
  4. YOU point in time backups now has a library with the PDB Snapshot Carousel. This gives you eight copies of your PDB, backed up every 24 hours.
  5. The Oracle Database password file is now located in the ORACLE_BASE file path.
  6. You can now install a read only ORACLE_HOME using roohctl -enable or dbca.
  7. Oracle 18c supports the merging and consolidation of partitions, as well as sub-partitions online.
  8. The SQL Performance Analyzer can now run in parallel with your SQL processes.

 

Performance features

  1. In the event of low memory, Oracle Database 18c can take out IM columns that are not accessed frequently out of memory.
  2. You can now use Oracle Database In-Memory features and functionality for external tables.
  3. The system global area has a memoptimized pool, which allows you to do quick searches when the fast lookup option is on. Memoptimized Rowstore will affect those queries that are most often made.
  4. You can clone pluggable databases on Oracle Automatic Storage Management using flex diskgroup.
  5. You no longer have to do a restricted mount to convert normal or redundant disk groups to flex disk groups.

 

Security features of Oracle Database 18c

  1. Oracle Database 18c is now directly integrated with Microsoft Active Directory Services.

 

Other features

  1. There are now additional initialization commands such as:
  • WALLET_ROOT
  • UNIFIED_AUDIT_SYSTEMLOG
  • TDE_CONFIGURATION
  • STANDBY_PDB_SOURCE_FILE_DIRECTORY
  • STANDBY_PDB_SOURCE_FILE_DBLINK
  • PRIVATE_TEMP_TABLE_PREFIX
  • PARALLEL_MIN_DEGREE
  • OPTIMIZER_IGNORE_PARALLEL_HINTS
  • OPTIMIZER_IGNORE_HINTS
  • MULTISHARD_QUERY_DATA_CONSISTENCY
  • MEMOPTIMIZE_POOL_SIZE
  • INMEMORY_OPTIMIZED_ARITHMETIC
  • INMEMORY_AUTOMATIC_LEVEL
  • FORWARD_LISTENER
  • ADG_ACCOUNT_INFO_TRACKING

 

  1. Instead of using dbms_lock, you can just run dbms_session.sleep to suspend a session.

Photo courtesy of Oracle.

Uncategorized

Performance Boost in MySQL 8.0.35…

Oracle has recently published interesting performance numbers that show MySQL 8.0.35 Enterprise Edition about 25%, or higher, faster than MySQL Community Edition.   A great...

Keep Reading

Uncategorized

Security Trends For 2024: SBOMs

A recent article on Forbes, linked below, lists five security trends that are likely to be important in 2024. Of course, AI-related security topics top...

Keep Reading

Uncategorized

Getting started with your first…

Anyone looking at writing their first Generative AI application should read this to save time. In June 2023, Google Cloud published a useful blog post,...

Keep Reading

Uncategorized

Read-Write and Read-Only query splitting…

Optimize the usage of the standby (secondary) read-only MySQL InnoDB Cluster servers by automatically and transparently distributing read-queries to them. A great feature in MySQL...

Keep Reading

Uncategorized

Considering Cloud Diversification?

Moving an enterprise to a Public Cloud can quickly feel like moving into a locked-in relationship with the Cloud vendor. One solution to diminish this...

Keep Reading

Uncategorized

Gartner: Global cloud consumption will…

Gartner forecasts that 2024 will see a 20% global cloud consumption increase from 2023 to $679B, while 2023 has seen an 18% increase from 2022...

Keep Reading

Uncategorized

ByteDance: Use AI for tuning…

ZDNet is reporting that a ByteDance (the maker of TikTok) Linux kernel developer has proposed to implement AI to tune the performance of Linux systems...

Keep Reading

AI Governance

What is AI TRiSM?

If reading now about AI TRiSM for the first time, it might be good read on and learn what it’s about because it leads the...

Keep Reading

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Live Chat | Emergency