| |
Improved optimizer statistics collection speed |
|
| |
Oracle 11g has improved the dbms_stats performance, allowing for an order of magnitude faster CBO statistics creation |
|
| |
|
|
| |
SQL execution Plan Management |
|
| |
Oracle 11g SQL will allow you to fix execution plans (explain plan) for specific statements, regardless of statistics or database version changes. |
|
| |
|
|
| |
Dynamic SQL |
|
| |
DBMS_SQL is here to stay. It's faster and is being enhanced. DBMS_SQL and NDS can now accept CLOBs (no more 32k limit on NDS). A ref cursor can become a DBMS_SQL cursor and vice versa. DBMS_SQL now supprts user defined types and bulk operations |
|
| |
|
|
| |
Fully Automatic SQL Tuning |
|
| |
The 10g automatic tuning advisor makes tuning suggestions in the form of SQL profiles that will improve performance. You can tell 11g to automatically apply SQL profiles for statements where the suggested profile give 3-times better performance that the existing statement. The performance comparisons are done by a new administrative task during a user-specified maintenance window. |
|
| |
|
|
| |
Improved SQL Access Advisor |
|
| |
The 11g SQL Access Advisor gives partitioning advice, including advice on the new interval partitioning. Interval partitioning is an automated version of range partitioning, where new equally-sized partitions are automatically created when needed. Both range and interval partitions can exist for a single table, and range partitioned tables can be converted to interval partitioned tables.
|
|
| |
|
|
