Features in Oracle Database 12c Release 1..........Released on June 26,2013
Quick Review
Database Level:
1.New background processes - LREG (listener Registration), SA (SGA allocator), RM.
2.RESOURCE role does not include UNLIMITED TABLESPACE any more
3.No need to shutdown database for changing archive log mode.
4.Like sysdba,sysoper & sysasm , we have new privielege,in oracle 12.1.0.
SYSBACKUP for backup operations
SYSDG for data guard operations
SYSKM for key management
5.Like sys,system we have new default sys users in oracle 12c release 1
sysbackup for backup operations
sysdg for data guard operations
syskm for key management
6.Oracle database 12c data pump will allow turning off redo for the import operation (only)
$impdp....transform=disable_archive_logging:y
7.Expdp has transport view,view_as_tables options.
$expdp.....VIEWS_AS_TABLES=test_view
8.New ENCRYPTION_PWD_PROMPT parameter allows you to specify wheather data pump should prompt you for the encryption password,rather than you entering it on the command line.
9.Enhanced stastics(Hybrid histogram for more than 254 distinct values,dynamic sampling upto eleven and stats automatically gathered during load).
10.Row pattern matching-"MATCH_RECOGNIZATION"(identification of patterns within a table ordered/sorted by the sql statement).
11.Adaptive execution plans(change of the plan at runtime).
12.Oracle 12c includes database level redaction,allowing granular control of access to sensitive data.
13.Dynamic sampling has been renamed to dynamic statistics in oracle 12c release 1.
14.Multi threaded database with parameter threaded_executions.Multiple Processes and multiple threads within each process provides improved performance and manageability through more efficient sharing of system and processor resources.
15.Oracle introduced parameter PGA_AGGREGATE_LIMIT which is a real/PGA memory limit.
16.UNDO for temporary tables can now be managed in TEMP,rather than the regular UNDO tablespace.Queried through v$tempundostat.
17.Oracle Enterprise Manage Express (lightweight EM cloud control 12c version) replaces the oracle database console and is installed automatically.
18.enable_ddl_logging
19.New type of sequences - session sequences,for global temporary tables
20.Materialized view out-of-place refresh.
DBMS_MVIEW.REFRESH('TEST_MV',method => '?',atomic_refresh => FALSE,
out_of_place =>TRUE);
21.CSSCAN (Character set scanner) and CSLATER utilities replaced with DMU(Database Migration Assistant for Unicode).
22.Monitor the privilege assignments easy in 12c oracle with DBMS_PRIVILEGE_CAPTURE.
23.SELECT ANY DICTIONARY no longer provides access to tables with password hashes(USER$ etc).
24.Reduces the size of redo associated with recovering the regular UNDO tablespace.
ORACLE GRID INFRASTRUCTURE NEW FEATURES
1.Introduction of Flex ASM,ASM would
Quick Review
Database Level:
1.New background processes - LREG (listener Registration), SA (SGA allocator), RM.
2.RESOURCE role does not include UNLIMITED TABLESPACE any more
3.No need to shutdown database for changing archive log mode.
4.Like sysdba,sysoper & sysasm , we have new privielege,in oracle 12.1.0.
SYSBACKUP for backup operations
SYSDG for data guard operations
SYSKM for key management
5.Like sys,system we have new default sys users in oracle 12c release 1
sysbackup for backup operations
sysdg for data guard operations
syskm for key management
6.Oracle database 12c data pump will allow turning off redo for the import operation (only)
$impdp....transform=disable_archive_logging:y
7.Expdp has transport view,view_as_tables options.
$expdp.....VIEWS_AS_TABLES=test_view
8.New ENCRYPTION_PWD_PROMPT parameter allows you to specify wheather data pump should prompt you for the encryption password,rather than you entering it on the command line.
9.Enhanced stastics(Hybrid histogram for more than 254 distinct values,dynamic sampling upto eleven and stats automatically gathered during load).
10.Row pattern matching-"MATCH_RECOGNIZATION"(identification of patterns within a table ordered/sorted by the sql statement).
11.Adaptive execution plans(change of the plan at runtime).
12.Oracle 12c includes database level redaction,allowing granular control of access to sensitive data.
13.Dynamic sampling has been renamed to dynamic statistics in oracle 12c release 1.
14.Multi threaded database with parameter threaded_executions.Multiple Processes and multiple threads within each process provides improved performance and manageability through more efficient sharing of system and processor resources.
15.Oracle introduced parameter PGA_AGGREGATE_LIMIT which is a real/PGA memory limit.
16.UNDO for temporary tables can now be managed in TEMP,rather than the regular UNDO tablespace.Queried through v$tempundostat.
17.Oracle Enterprise Manage Express (lightweight EM cloud control 12c version) replaces the oracle database console and is installed automatically.
18.enable_ddl_logging
19.New type of sequences - session sequences,for global temporary tables
20.Materialized view out-of-place refresh.
DBMS_MVIEW.REFRESH('TEST_MV',method => '?',atomic_refresh => FALSE,
out_of_place =>TRUE);
21.CSSCAN (Character set scanner) and CSLATER utilities replaced with DMU(Database Migration Assistant for Unicode).
22.Monitor the privilege assignments easy in 12c oracle with DBMS_PRIVILEGE_CAPTURE.
23.SELECT ANY DICTIONARY no longer provides access to tables with password hashes(USER$ etc).
24.Reduces the size of redo associated with recovering the regular UNDO tablespace.
ORACLE GRID INFRASTRUCTURE NEW FEATURES
1.Introduction of Flex ASM,ASM would
