Pages

Sunday, February 28, 2016

Top New Features in Oracle 11g

Top New Features in Oracle 11g


Database Replay Explore Database Replay, the new tool that captures SQL statements and lets you replay them at will.

Partitioning Learn about Referential, Internal, and Virtual Column partitioning; new sub-partitioning options; and more.

Transaction Management Get an introduction to Flashback Data Archive and explore Enterprise Manager's LogMiner interface.

Schema Management Add columns with a default value easily and explore invisible indexes, virtual columns, and read only tables.

SQL Plan Management Use bind variables that pick the right plan every time and ensure a new execution plan is perfect before it's used.

SQL Performance Analyzer Accurately assess the impact of rewriting of SQL statements and get suggested improvements.

SQL Access Advisor Get advice about optimal table design based on actual use of the table, not just data.

PL/SQL: Efficient Coding Triggers that fire several times at different events and ability to force triggers of the same type to follow a sequence are some new gems.

RMAN Explore Data Recovery Advisor, do parallel backup of the same file, and create and manage virtual catalogs.

Security Learn about Tablespace Encryption, case-sensitive passwords, data masking, and other features.

Automatic Storage Management Learn about new SYSASM role, variable extent sizes, and other ASM improvements.

Manageability Explore automatic memory management, multicolumn statistics, online patching, and more features.

Caching and Pooling Explore SQL Result Cache, PL/SQL Function Cache, and Database Resident Connection Pooling.

SQL Operations: Pivot and Unpivot Present information in a spreadsheet-type crosstab report from any relational table using simple SQL, and store any data from a crosstab table to a relational table.

SecureFiles Explore next-generation LOBs: LOB encryption, compression, deduplication, and asynchronicity.

Resiliency Explore Automatic Health Monitor, Automatic Diagnostic Repository, and other new resiliency features.

Data Guard Query the physical standby database in real time without shutting down recovery, just for starters.

PL/SQL Performance Explore in-lining of code, "real" native compilation, PLS timer, use of simple integer, and more.

Data Warehousing and OLAP Get a tour of new features in these areas, including Cube Organized MVs.

No comments:

Post a Comment