On this page I collect all references to new features Oracle 11g
Installation
- Oracle RAC 11G on Oracle Enterprise Linux 6 Virtual Box
- Oracle RAC 11G on Oracle Enterprise Linux 5 Virtual Box
- Oracle 11G on Oracle Enterprise Linux 7
- Oracle 11G on Oracle Enterprise Linux 6
- Oracle 11G on Oracle Enterprise Linux 5
Miscellanous Features
- Virtual columns – Oracle Database 11G release 2 (11.2)
-
Locking changes – Oracle Database 11G release 2 (11.2)
-
Invisible indexes – Oracle Database 11G release 2 (11.2)
-
SQL Result Cache – Oracle Database 11G release 2 (11.2)
-
PL/SQL Result Cache – Oracle Database 11G release 2 (11.2)
-
Temporary tablespace – Oracle Database 11G release 2 (11.2)
-
Easy SPFILE/PFILE recovery – Oracle Database 11G release 2 (11.2)
-
Regular expressions – Oracle Database 11G release 2 (11.2)
-
Sequence, CONTINUE, named and mixed notation SQL, READ ONLY tables – Oracle Database 11G release 2 (11.2)
- Compound Triggers – Oracle Database 11G release 2 (11.2)
- Direct NFS client – Oracle Database 11G release 2 (11.2)
- PIVOT, UNPIVOT – Oracle Database 11G release 2 (11.2)
- Database resident connection pool – Oracle Database 11G release 2 (11.2)
- Real time sql monitoring – Oracle Database 11G release 2 (11.2)
- UTL_MATCH similarity strings – Oracle Database 11G release 2 (11.2)
- Online patching – Oracle Database 11G release 2 (11.2)
- Table compression – Oracle Database 11G release 2 (11.2)
- DB smart flash cache – Oracle Database 11G release 2 (11.2)
- Instance caging – Oracle Database 11G release 2 (11.2)
- Flashback Data Archive – Oracle Database 11G release 2 (11.2)
- New parallel parameters and options – Oracle Database 11G release 2 (11.2)
- Dynamic SQL changes in PL/SQL 11G – Oracle Database 11G release 2 (11.2)
- Tracing PL/SQL using DBMS_TRACE – Oracle Database 11G release 2 (11.2)
- PL/SQL Hierarchical Profiler Oracle Database 11G release 2 (11.2)
- Statistics improvements Oracle Database 11G release 2 (11.2)
- Deferred segment creation on demand – Oracle Database 11G release 2 (11.2)
- Oracle SecureFile LOBs – Oracle Database 11G release 2 (11.2)
- Transparent Data Encryption (TDE) – Oracle Database 11g release 2 (11.2)
- sqlplus catch and log all ORA- errors