That’s a personal, quite unsorted list of (new or older) features I recently collected. All of them are things, I’d consider valuable or at least important to care about as soon as 11g is involved. It might be for system architecture knowledge, concept tasks, DBA hands-on, good-to-know or any other thing that my happen in a DBA life.
- Password profile (user pw expires after 180 days by default!)
- (Client) Result cache
- (DB_KEEP_CACHE / DB_RECYCLE_CACHE plus corresponding segment configuration)
- the adrci command line tool, for the least example to view an alert log tail-like in windows
- direct NFS supported
- fast mirror resync in ASM
- preferred read mirror in ASM
- Optimizer simulation capabilities
- Index invisible after creation
- Statistics inactive after creation
- DB replay feature with 10g partially possible (patch apply necessary)
- I/O-calibration + I/O statistics
- Adaptive cursor sharing
- Resource manager with I/O quotas
- Interval partitioning (auto-create addition to range partitioning)
- PL/SQL native code
Look them up in Oracle Docs, and consider using them someday/somehow/somewhere.
Good, bugfree luck
Usn