Enjoy the series, and the release!
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.
|
Edition-Based Redefinition
It's revolutionary: Patch or update your application's data objects while the application remains in uninterrupted use (in Release 2 only).
| Schema Management
Add columns with a default value easily and explore invisible indexes, virtual columns, and read only tables.
|
Patching and Upgrades, RAC One Node, and Clusterware
Learn how to enable a single name for the cluster, enable HA for a single-instance database, place OCR and voting disks on ASM, and more (in Release 2 only).
| Data Warehousing and OLAP
Get a tour of new features in these areas, including Cube Organized MVs, a new Analytic Workspace Manager, Query Rewrite extended to subqueries and remote tables, and more.
|
PL/SQL Performance
Explore in-lining of code, "real" native compilation, PLS timer, use of simple integer, and more.
| 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.
|
Transaction Management
Get an introduction to Flashback Data Archive and explore Enterprise Manager's LogMiner interface.
| Security
Learn about Tablespace Encryption, case-sensitive passwords, data masking, and other features.
|
SQL Performance Analyzer & Real-Time SQL Monitoring
Learn how to accurately predict changes on the actual SQL statements issued against your database - plus, monitor SQL performance in real time.
| Oracle Exadata Simulator
Predict how your statements will behave in Oracle Exadata Database Machine using any Oracle Database 11g Release 2 EE database (using SQL Performance Analyzer).
|
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.
| Manageability
Explore automatic memory management, multicolumn statistics, online patching, and more features.
|
SQL Access Advisor
Get advice about optimal table design based on actual use of the table, not just data.
| 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.
|
Backup and Recovery
Explore Data Recovery Advisor, do parallel backup of the same file, create and manage virtual catalogs, and undrop tablespaces.
| Resiliency
Explore Automatic Health Monitor, Automatic Diagnostic Repository, and other new resiliency features.
|
Automatic Storage Management
Learn about new SYSASM role, variable extent sizes, and other ASM improvements.
| Compression
Support for data compression is nothing new in Oracle Database, but 11g takes the concept to a new level with Advanced and Hybrid Columnar Compression.
|
Caching and Pooling
Explore SQL Result Cache, PL/SQL Function Cache, and Database Resident Connection Pooling.
| Data Guard
Query the physical standby database in real time without shutting down recovery, just for starters.
|
SecureFiles
Explore next-generation LOBs: LOB encryption, compression, deduplication, and asynchronicity.
| And Don't Forget...
COPY command, Export/Imports, Data Pump and SQL*Plus improvements, Scheduler email notification, and more.
|
No comments :
Post a Comment