New Features

Over here I will be adding all those new features which were added/updated as per the version release. The post will be updated as an when I come across any of those new features.

#################### Oracle Database 9i Release 1 ########################

1. Oracle Managed Files - DB_CREATE_FILE_DEST introduced
Using Oracle-Managed Files - Part Number A96521-01

2. Introduced the "AND DATAFILES" clause to the DROP TABLESPACE statement which will remove datafiles physically.
DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES;

#################### Oracle Database 9i Release 2 ########################

1. logical standby database
   Logical Standby Databases - Part Number B14239-05

#################### Oracle Database 10g release 10.1 #################### 
1. Snapshot privilege name have been changed to Materialized View. The new name appear in all data dictionary views. Both old and new name are accepted by the GRANT and REVOKE SQL statements.

#################### Oracle Database 10g release 10.2 ####################

1. Introduced the DROP DATAFILE, if the datafile is non-empty, it cannot be removed.
Note: ALTER DATABASE DATAFILE OFFLINE DROP doen't remove a datafile. It offline the datafile with a purpose of dropping the tablespace.

2. 10g R2 New Feature TDE : Transparent Data Encryption [ID 317311.1]

#################### Oracle Database 11g release 11.1 #################### 
1. Oracle Database 11.1 New Features : Summary [ID 466931.1] 

2. 11g ASM New Features Technical White Paper [ID 551205.1] 

3. Redo Gap Detection and Resolution 
   Redo Transport Compression and Parallel Redo Transport Network Sessions 

4. RMAN 'Duplicate From Active Database' Feature in 11G [ID 452868.1]

5. INTERVAL PARTITIONING
11g New Features: INTERVAL PARTITIONING [ID 805976.1]

6. New Features: Partitioning to Perfection

7. Automatic Diagnostic Repository Command Interpreter
adrci: A survival guide for the DBA

8. Fast Incremental Backups were not possible on standby databases till 10g but from 11g Fast Incremental Backups are available on standby databases also. Only enable block change tracking at a physical standby database if a license for the Oracle Active Data Guard option is enabled.

#################### Oracle Database 11g release 11.2 ####################

1. Cardinality Feedback
Cardinality Feedback - Frequently Asked Questions [ID 1344937.1]

2. Deferred Segment Creation
Deferred Segment Creation - Part Number E17120-07
11.2 Database New Feature Deferred Segment Creation [Video] [ID 887962.1]

3. Restarting DUPLICATE After a Failure

4. alter database link instead of recreating it
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s