11g New Features List

Parameter List :-

MEMORY_TARGET
MEMORY_MAX_TARGET
-V$MEMORY_TARGET_ADVICE
DIAGNOSTIC_DEST
-$ORACLE_BASE/diag/rdbms/$INSTANCE_NAME/$ORACLE_SID
-$ORACLE_HOME/log.
RESULT_CACHE_MODE
RESULT_CACHE_MAX_RESULT
RESULT_CACHE_MAX_SIZE
DDL_LOCK_TIMEOUT
DB_ULTRA_SAFE
SEC_CASE_SENSITIVE_LOGON
SEC_MAX_FAILED_LOGIN_ATTEMPTS

-------------------------------------------------
New Features of 11g
-------------------------------------------------
1)database reply
2)sql performance analyzer (SPA,DBMS_SQLPA)
3)sql repair advisor

4)Data Recovery Advisor with RMAN (DRA)
-RMAN>LIST FAILURE;
-RMAN>list failure 722 detail;
-RMAN>LIST OPEN;
-RMAN>LIST CLOSED;
-RMAN>ADVISE FAILURE;
-RMAN>REPAIR FAILURE PREVIEW;
-RMAN>repair failure;

5)sql test case builder (DBMS_SQLDIAG SQL Test Case Builder is a SQL script that contains the commands
required to recreate all the necessary objects and the environment)

6)Automatic Diagonastic repositroy (ADR)
-adrci tool
-Problems and Incidents
-V$DIAG_INFO
-ips create package
-ips generate package 1 in /u01/myfiles/incidents incremental

6.1)Database Health Monitor (DHM)
-V$HM_CHECK
-V$HM_RUN
-V$HM_FINDING
-V$HM_RECOMMENDATION
-DBMS_HM
-adrci>show hm_run

7)Oracle flashback
LogMinner
Transaction callout
Flashback data archive

8)Database connection resident pooling
9)Comparing and Synchronzing database objects
10)Changing stats preference
Multicolumn statistics
Expression statistics
11)SQL Plan management
12)Access control list
13)Real time sql monitor
14)Pl/SQL Native compliation
15)Adaptive cursor sharing
16)Rman
Block Recovery
Rman substitution variable
Rman configuration parameter
multisection backup
creating archival backup
validate (new command)
Archive log deletion policy
Active database duplication
Importing and moving recovery catalog
virtual private catalog
17)Datapump Utility
encryption enhancement
remap_data
remap_table
reuse_dumpfile
18)ASM
sysasm privilage and osasm group
diskgroup attribute
asmcmd utility
remap
md_backup
md_restore
19)Parition enhancement
-Reference Partitions
-Interval Partitioning
-Extended Composite Partitioning
Composite List-Range
Composite List-Hash
Cmposite List-List
-Virtual Column-Based Partitioning
-System Partitioning
20)Active dataguard
Stapshot standby
------------------------------------------------------
RAC 11g New Features
------------------------------------------------------
1)SCAN(Single Client Access Network) and GNS (Grid Naming Service)
2)CRS file in ASM
3)VD autobackup
4)CTSS (Cluster time synchronisation service)
5)ASM Cluster file system (ACFS)
6)OLR (Oracle Local Registry)
7)Cluster + ASM having only one home called GRID home