New features related to Oracle database performance in Oracle 12.2.0.1, 12.2.0.1oracle

New features related to Oracle database performance in Oracle 12.2.0.1, 12.2.0.1oracle

Changes in Oracle Database 12c Release 2 (12.2.0.1)

The following are changes in Oracle Database Performance Tuning Guide for Oracle Database 12c Release 2 (12.2.0.1 ).

New Features

The following features are new in this release:

1. Per-process PGA limits

A runaway query consuming excessive amount of PGA memory can create a serious performance problem in Oracle Database. in a multitenant container database (CDB), this type of query can affect the performance of all the pluggable databases (PDBs ). to prevent this issue, you can now specify an absolute limit for the amount of PGA memory that can be used by each session in a participating consumer group.

Excessive consumption of PGA memory out-of-control queries may cause serious performance problems in Oracle databases. In a multi-tenant container database (CDB), such queries affect the performance of all pluggable databases (PDB. To prevent this problem, you can specify an absolute limit for the amount of PGA memory that can be used by each session in a specific user group.

2. Prespawned server processes

Oracle Database now prespawns pools of server processes when dedicated broker connection mode is enabled or threaded execution mode is enabled. This feature improves the client connection performance in these modes of database operation.

When the dedicated proxy connection mode is enabled or the thread execution mode is enabled, the Oracle database is now pre-allocated to the server process pool. This function improves the client connection performance in these database operation modes.

3. Automatic Workload Repository (AWR) support for multitenant environment

You can now capture Automatic Workload Repository (AWR) data for the PDBs in a multitenant environment. This feature enables performance tuning of PDBs in a multitenant environment.

You can now capture PDB's automatic workload repository (AWR) data in a multi-tenant environment. This function can be used to adjust the performance of PDB in a multi-tenant environment.

4. Automatic Workload Repository (AWR) support for Oracle Active Data Guard standby databases

You can now capture Automatic Workload Repository (AWR) data for Oracle Active Data Guard standby databases. This feature enables performance tuning of Oracle Active Data Guard standby databases.

You can now capture the automatic workload of the Oracle Active Data Guard slave database (AWR) Data. This feature supports Oracle Active Data Guard backup database performance adjustment.

5. Direct NFS Client performance improvement features-Parallel NFS and Direct NFS Dispatcher

Parallel NFS is an optional feature of Oracle Direct NFS Client that is introduced in NFS version 4.1. This feature enables highly scalable distributed NAS storage for better I/O performance.

The Direct NFS dispatcher feature extends lidates the number of TCP connections that are created from a database instance to an NFS server. In large database deployments, using Direct NFS dispatcher improves scalability and network performance.

Parallel NFS is an optional feature of Oracle Direct NFS Client introduced in NFS 4.1. This feature supports highly scalable distributed NAS storage to improve I/O performance.

The Direct NFS scheduler combines the number of TCP connections created from the database instance to the NFS server. In large-scale database deployment, the Direct NFS scheduler can improve scalability and network performance.

6. Service-oriented buffer cache access optimization

Cluster-managed services allocate workloads internal SS various Oracle Real Application Clusters (Oracle RAC) database instances. these services also access data from the Oracle RAC database instances and provide it to the applications requesting the data. the Service-oriented Buffer Cache Access Optimization feature allows Oracle RAC to cache service-specific data that is frequently accessed by each of these services, thus improving the data access time for the services. this data-dependent caching also leads to more consistent response times when accessing data processing SS Oracle RAC database instances. this feature is permanently enabled in Oracle RAC.

The cluster management service allocates workload in each Oracle Real Application Clusters (Oracle RAC) database instance. These services also access data from the Oracle RAC database instance and provide it to the application requesting data. The service-oriented buffer cache access optimization function allows Oracle RAC to cache service-specific data frequently accessed by each service, thus shortening Service Data Access time. When accessing data across Oracle RAC database instances, this data-dependent high-speed cache will also lead to a more consistent response time. This feature is permanently enabled in Oracle RAC.