Difference between 10g and 11g

Differences between Oracle DBA 10g and 11g.

what are the main differeneces between Oracle 10g and 11g? 

A few of the main enhancements that are gained in Oracle 11g over Oracle 10g can be highlighted
as follows:

1. Simplified and improved automatic memory
management

2. New fault diagnostic infrastructure to prevent, detect, diagnose, and help resolve critical database errors

3. Virtual Private Catalog

4. Flashback Database Archive (FBDA)

5. Read only table

 Ex: sql>alter table scott.emp read only; 

        sq>alter table scott.emp read write;

6. Automatic data recovery (ADR) : when oracle database is corrupted it is possible to recover oracle database with ADR. it uses database diagnostic information for repairing the database. 

Ex: $rm user01.dbf 

RMAN>connect target; RMAN>list failure; (its shows error in summary) 

RMAN>advise failure (it give clearly that damaged file with name it give advise) 

RMAN> repair failure preview; (it give the preview before apply(repair failure or right command) RMAN>repair failure; ( type yes & enter now ur database open)

7. Invisible Indexes: when index is declared in a table…. Of the data is fix but insertion, updation, deletion takes time due to the requirement of reorganization of a index

ex: sql> alter index index_name invisible/visible; 

if we are in invisible mode we can use easily DML operation after finished work we can do visible mode of index

8. Virtual column

9. Enhanced security for password-based authentication by enabling use of mixed case in passwords Or secured case sensitive password

Sql>show parameter SEC_CASE_SENSITIVE_LOGON;

Sql>Alter system set SEC_CASE_SENSITIVE_LOGON;

Note: it is case sensitive for password but not for user name, by default value is set as ‘TRUE’ 

10. Table-space-level encryption Ability to online redefine tables that have materialized view logs