If you are not aware, Oracle 18c was released on Friday, 16th Feb. It is the patchset version 12.2.0.2 and also the very first on the new release model introduced by Oracle(https://mikedietrichde.com/2017/11/07/ru-rur-recommendations-facts/).
The name has simply been changed to reflect the year in which it has been released.
Note:Oracle 18c is not an Autonomous database. If we buy an Autonomous Database cloud service on oracle Public Cloud, that qualifies as the autonomous database. You can refer to oracle base blog:https://oracle-base.com/blog/2018/01/05/oracle-database-18c-is-not-an-autonomous-database-update/
How the new version number works is explained in MOS Doc ID 2285040.1 and the release schedule for these database versions are explained in the MOS Doc ID 742060.1.
Some of the new features are:
1. Read Only Oracle Home (ROOH)
2. Columnar Format Exadata Flash Cache Enhancements
With Oracle Database 18c we now support accessing non-HCC objects in the Exadata Flash cache in full Database In-Memory columnar format. In 12.2 this was restricted to just HCC objects.
3. Scalable Sequences
A scalable sequence is particularly efficient when used to generate unordered primary or unique keys for data ingestion workloads having high level of concurrency. Scalable sequences significantly reduce the sequence and index block contention.
4. Converting Normal or High Redundancy Disk Groups to Flex Disk Groups without Restricted Mount
You can convert a conventional disk group (disk group created before Oracle Database18c) to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option.
5. ALTER SYSTEM CANCEL SQL
Another way to kill/cancel a SQL in a session.
The syntax would be like …
ALTER SYSTEM CANCEL SQL ‘SID, SERIAL[, @INST_ID][, SQL_ID]’;
e.g. ALTER SYSTEM CANCEL SQL ‘448, 98175, @1, 761hchah78addfj’;
6. The default value of PARALLEL_THREADS_PER_CPU is finally set 1 as default!
PARALLEL_THREADS_PER_CPU describes the number of parallel execution processes or threads that a CPU can handle during parallel execution. Good Move! 🙂
7. For users of Exadata and Real Application Clusters (RAC), Oracle Database 18c brings changes that will enable a significant reduction in the amount of undo that needs to be transferred across the interconnect. It achieves this by using RDMA, over the Infiniband connection, to access the undo blocks in the remote instance. This feature combined with a local commit cache significantly improves the throughput of some OLTP workloads when running on top of RAC.
8. 18c Authenticate and authorize Oracle users directly with Microsoft Active Directory
9. New Oracle Spatial features in Oracle Database 18c include distributed transactions, sharding, easier to use web services admin console.
Where to get started:
https://docs.oracle.com/en/database/oracle/oracle-database/18/index.html
Oracle 18c new feature:-https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-04A4834D-848F-44D5-8C34-36237D40F194
https://blogs.oracle.com/database/oracle-database-18c-%3a-now-available-on-the-oracle-cloud-and-oracle-engineered-systems
Please keep in mind that this is not yet released for On premises. As of now, Oracle 18c is only available for Oracle public Cloud and Oracle Engineered Systems.
Keep Learning
The name has simply been changed to reflect the year in which it has been released.
Note:Oracle 18c is not an Autonomous database. If we buy an Autonomous Database cloud service on oracle Public Cloud, that qualifies as the autonomous database. You can refer to oracle base blog:https://oracle-base.com/blog/2018/01/05/oracle-database-18c-is-not-an-autonomous-database-update/
How the new version number works is explained in MOS Doc ID 2285040.1 and the release schedule for these database versions are explained in the MOS Doc ID 742060.1.
Some of the new features are:
1. Read Only Oracle Home (ROOH)
2. Columnar Format Exadata Flash Cache Enhancements
With Oracle Database 18c we now support accessing non-HCC objects in the Exadata Flash cache in full Database In-Memory columnar format. In 12.2 this was restricted to just HCC objects.
3. Scalable Sequences
A scalable sequence is particularly efficient when used to generate unordered primary or unique keys for data ingestion workloads having high level of concurrency. Scalable sequences significantly reduce the sequence and index block contention.
4. Converting Normal or High Redundancy Disk Groups to Flex Disk Groups without Restricted Mount
You can convert a conventional disk group (disk group created before Oracle Database18c) to an Oracle ASM flex disk group without using the restrictive mount (MOUNTED RESTRICTED) option.
5. ALTER SYSTEM CANCEL SQL
Another way to kill/cancel a SQL in a session.
The syntax would be like …
ALTER SYSTEM CANCEL SQL ‘SID, SERIAL[, @INST_ID][, SQL_ID]’;
e.g. ALTER SYSTEM CANCEL SQL ‘448, 98175, @1, 761hchah78addfj’;
6. The default value of PARALLEL_THREADS_PER_CPU is finally set 1 as default!
PARALLEL_THREADS_PER_CPU describes the number of parallel execution processes or threads that a CPU can handle during parallel execution. Good Move! 🙂
7. For users of Exadata and Real Application Clusters (RAC), Oracle Database 18c brings changes that will enable a significant reduction in the amount of undo that needs to be transferred across the interconnect. It achieves this by using RDMA, over the Infiniband connection, to access the undo blocks in the remote instance. This feature combined with a local commit cache significantly improves the throughput of some OLTP workloads when running on top of RAC.
8. 18c Authenticate and authorize Oracle users directly with Microsoft Active Directory
9. New Oracle Spatial features in Oracle Database 18c include distributed transactions, sharding, easier to use web services admin console.
Where to get started:
https://docs.oracle.com/en/database/oracle/oracle-database/18/index.html
Oracle 18c new feature:-https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-04A4834D-848F-44D5-8C34-36237D40F194
https://blogs.oracle.com/database/oracle-database-18c-%3a-now-available-on-the-oracle-cloud-and-oracle-engineered-systems
Please keep in mind that this is not yet released for On premises. As of now, Oracle 18c is only available for Oracle public Cloud and Oracle Engineered Systems.
Keep Learning
No comments:
Post a Comment