Explore Database Replay, the new tool
that captures SQL statements and lets you replay them at will.
Learn about Referential, Internal, and
Virtual Column partitioning; new sub-partitioning options; and more.
It's revolutionary: Patch or update your
application's data objects while the application remains in uninterrupted use
(in Release 2 only).
Add columns with a default value easily
and explore invisible indexes, virtual columns, and read only tables.
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).
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.
Explore in-lining of code,
"real" native compilation, PLS timer, use of simple integer, and
more.
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.
Get an introduction to Flashback Data
Archive and explore Enterprise Manager's LogMiner interface.
Learn about Tablespace Encryption,
case-sensitive passwords, data masking, and other features.
Learn how to accurately predict changes
on the actual SQL statements issued against your database - plus, monitor SQL
performance in real time.
Predict how your statements will behave
in Oracle Exadata Database Machine using any Oracle Database 11g Release 2
EE database (using SQL Performance Analyzer).
Use bind variables that pick the right
plan every time and ensure a new execution plan is perfect before it's used.
Explore automatic memory management,
multicolumn statistics, online patching, and more features.
Get advice about optimal table design
based on actual use of the table, not just data.
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.
Explore Data Recovery Advisor, do
parallel backup of the same file, create and manage virtual catalogs, and
undrop tablespaces.
Explore Automatic Health Monitor,
Automatic Diagnostic Repository, and other new resiliency features.
Learn about new SYSASM role, variable
extent sizes, and other ASM improvements.
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.
Explore SQL Result Cache, PL/SQL
Function Cache, and Database Resident Connection Pooling.
Query the physical standby database in
real time without shutting down recovery, just for starters.
Explore next-generation LOBs: LOB
encryption, compression, deduplication, and asynchronicity.
COPY command, Export/Imports, Data
Pump and SQL*Plus improvements, Scheduler email notification, and more.
No comments:
Post a Comment