Oracle 11gr2 performance optimization enhancements

Although 11g is not officially used, you still need to pay attention to the new features of Oracle 11gr2. The following is an introduction to Oracle 11gr2 performance optimization:

 

Note:

Stored outlines = storage Overview

SQL Plan Management (SPM) = SQL Plan Management

 

1. added the ability to migrate stored outlines to SQL Plan Management (SPM ).

Stored outlines lacks the flexibility and adaptability of SQL scheduler management. By providing the migration path, the stored outlines used by the original application can be transparently migrated and the SPM enhancement function can be used immediately.

 

2. You can specify the client result set cache mode in the table description.
Table annotations support provides the ability to annotate a table as being cache worthy, which enables applications to leverage client and server result caching through deployment time knobs as opposed to making application changes. in addition, this feature provides automatic Client Cache invalidation.

This feature allows non-intrusive application performance acceleration using client and server result caches.

 

The above is the original text, which is a bit difficult to understand. In reality, in the past, only the hint/* + result_cache */method was used to describe whether the client result set is cached, now you can add attributes to the table to specify the client result set caching method for the table. This allows you to enjoy the client result set caching function without modifying the SQL statement. The specific syntax is as follows:

 

Create | alter table [<schema>.] <Table>... [result_cache (mode {force | default})]
Alter table Foo result_cache (mode default );

 

3. Support for 4 kb sector disk drive

The current disk drive generally uses a 512-byte sector. The disk drive vendor is upgrading to a 4 kb sector drive because it can provide higher capacity at a lower cost.
However, if you use a 4 kb disk drive like a 512-byte sector, the performance will be low (because it needs to run in the 512-byte virtual mode ). This new feature allows Oracle to use a 4 kb disk drive without any performance loss. ASM provides the ability to migrate a disk group from a 512-byte sector to a 4 kb sector disk drive.

 

This new feature allows customers to take full advantage of the new generation of high-capacity disk drives.

 

Note: the hard disk in the 4kb sector has been raised for a long time, but it seems that I haven't seen it yet. The main reason may be the compatibility of the operating system and application software.

 

 

The overall perception is that the performance is very little enhanced. I think the biggest change to 11gr2 is the ASM Cluster File System (ACFs.