Oracle Database 12c New Features
Off course friends, the Oracle 12c database has been launched before 2 months back. C stands for cloud computing in Oracle 12c database. Indeed, this new version launched with some new features and fixed with some old known bugs. Every new Oracle release is having some good new features and Oracle database 12c is having some good new features too. Most of excellent features are following.
Following are some nice Oracle 12c Database New Features:
Online data file movement:
This feature helps you to rename, and move active datafile online. It is very useful for database reorganization or any disk movement for managing space.
Online table partition or sub-partition movement:
Now in Oracle database 12c, you can move table partition or sub-partition online while database is online and users are working. This is best feature of data warehousing database where space management concern and disk space becomes full.
Invisible column:
This is amazing new feature of Oracle 12c database because virtual column and invisible index was introduced in Oracle 11g but now latest version introduced invisible column. You can create table with invisible column and modify column as an invisible too. The characteristic of the invisible column is in a simple SQL query where column doesn’t specify then you cannot see an invisible column but if you would specify in your SQL statement then and only we are able to see this column and data.
Multiple indexes on the same column:
In Oracle 12c, creation of multiple indexes on same column is available. This feature doesn’t available in prior Oracle database version.
DDL logging:
This option helps you to audit every DDl command execution in database. Initialization parameter ENABLE_DDL_LOGGING=true helps to enable this feature and log file generates in Diag/rdbms/log location.
Temporary undo generation:
This feature helps to eliminate unnecessary redo and undo the generation of temporary segment usage. Using the initialization parameter TEMP_UNDO_ENABLED, you can enable this option. Temporary undo will be generated in temporary tablespace instead of undo tablespace.
New backup user privilege:
SYSBACKUP privilege introduced to manage RMAN backup. This feature is helpful to provide SYSDBA to RMAN as security risk.
RMAN a SQL execution:
You can execute SQL and PL/SQL command from RMAN interface directly without any interrupt or prefix.
Table level recovery in RMAN:
RECOVER TABLE command introduced for RMAN table level recovery in Oracle 12c database.
PGA size Restriction:
Now you can put restrictions of PGA sizing for expanding or minimizing with the help of the initialization parameter PGA_AGGREGATE_LIMIT.
Table partition maintenance enhancements:
You can add, drop, split, and truncate multiple partitions in same single SQL statement.
Database upgrade improvements:
New pre-upgrade database activity There is a new script available for verification of database upgrade called preupgrd.sql. During the execution of this script and file upgrade_fixup.sql generated, and you can fix up all database issues before proceeding for upgrading.
Restore/Recover data file over the network:
We can restore and recover data file, redo log file, control file from standby database through RMAN backup.
Data Pump enhancements:
We can suppress unnecessary archive log generation during datapump import using command TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y. This feature boosts performance of import process.
We can extract data from the view to physical table using the command views_as_tables=list of views:list of tables. This is a useful option for the data mart.
Real-time ADDM:
This feature is available if you are using Oracle Enterprise Manager Control. Using the Emergency Monitoring option, you can be able to populate real-time ADDM.
Concurrent statistics gathering:
We can collect table, and index statistics concurrently to gather.
SQL Enhancements:
Now we can use TRUNCATE TABLE CASCADE option with the truncate table command. This DDL command truncates the table and data from the dependent object simultaneously.
FETCH FIRST N ROWS ONLY option we can use to get the first N rows from a select statement.
We can create a session level sequence using the session/global option in create sequence command.
Pluggable and Container Database:
One of the exclusive new features of Oracle Database 12c is a pluggable database and container database for reducing multiple databases and instances at a time and reducing space management with memory management.
There were more new features introduced for Oracle ASM, Oracle RAC, Data Guard, and Oracle GRID.
Presentation and slideshow available at http://www.slideshare.net/giteshtrivedi/oracle-database-12c-new-features-28551259
If you like this post and slideshow then kindly make like to our official FACEBOOK fanpage at https://www.facebook.com/dbametrix
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.