Shulou(Shulou.com)05/31 Report--

What are the new features of oracle18c? in view of this question, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

Oracle announced that Database 18c has been released, but it is still the first to be released in an all-in-one environment on Oracle Cloud.

Friends who are looking forward to having a taste can pass the

New Default Location of Oracle Database Password File, in 18c, the default location of the password file is migrated to the $ORACLE_BASE directory to remove the changes to $ORACLE_HOME.

Read-Only Oracle Home, set $ORACLE_HOME to read-only, then the change file will be created in $ORACLE_BASE to facilitate standardization, distribution sharing, rolling upgrades, etc.

RPM-based Database Installation, and finally Oracle provides a RPM way of installation.

Online Merging of Partitions and Subpartitions, which can merge partitions and self-partitions online to enhance online maintainability

Scalable Sequences, an adaptive sequence, is designed to reduce competition under highly concurrent DML, by building discontinuous sequences, breaking up and reducing split competition on similar indexes, etc., which is an enhancement from Oracle optimization best practices

ASM Database Cloning,ASM database cloning supports multi-tenant data, which provides a native data-based cloning method through ASM redundancy, which can replace storage-level cloning or replication synchronization.

Concurrent SQL Execution with SPA, which speeds up the testing process of SPA through parallel execution, is useful for upgrades. Cloud and Enmo have their own internal parallel version, and now Oracle has introduced this feature.

Modifying the Partitioning Strategy, you can change the partition policy of the heap table online or offline, such as changing HASH partition to range partition.

Automatically correct Non-logged Blocks ata Data Guard Standby Database, automatically correct bad block problems caused by Nologging

Shadow Lost Write Protection, shadow protection for write loss, can be enabled at the tablespace, database, and data file level to actively check in advance and prevent write loss.

The answers to the questions about the new features of oracle18c are shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.