Oracle Database Version 11.1G new features

Leave a reply

Oracle Database version 11.1g new features

Oracle Database 11g makes database infrastructure far more efficient, resilient, and manageable. For example, very compelling new features in the realm of partitioning ease the design and management of partitioned tables immensely.

Following are the list of some new feature included in 11g release 1:

1) SQL Performance Analyzer (SPA)
2) Database Replay
3) Automatic Memory Tuning
4) Case sensitive password
5) Virtual columns and indexes
6) Interval Partition and System Partition
7) Feature based patching
8) RMAN Undo bypass
9) New default Audit setting
10) Faster DML triggers
11) Parallel backup and restore for very large files
12) Improved block media recovery performance
13) Enhanced Index rebuild online: Online index build with NO pause to DML.
14) No recompilation of dependent objects
15) Fast incremental backups on physical standby database.

Advertisements

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.