{"id":10398,"date":"2016-03-19T04:13:38","date_gmt":"2016-03-19T08:13:38","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=10134"},"modified":"2017-04-12T07:20:54","modified_gmt":"2017-04-12T11:20:54","slug":"five-new-features-in-oracle-database-12c-for-dbas-part1","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/","title":{"rendered":"Five New Features in Oracle Database 12c for DBAs : Part1"},"content":{"rendered":"<p>This post is series of <strong>Oracle Database 12c new features<\/strong>, If you are new to <strong>PDB<\/strong> &amp; <strong>CDB<\/strong> and challenges encountered in database consolidation then look at post <a href=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/02\/oracle-database-12c-multitenant-architecture-container-or-pluggable-database-cdbpdb\/\" target=\"_blank\">here<\/a><\/p>\n<p>In this article, I shall be extensively exploring some of the very important new additions\/enhancements introduced in Oracle Database 12c in the area of <strong>Database Administration, RMAN, High Availability and Performance Tuning.\u00a0<\/strong><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>New Features in Oracle DBA 12C:<\/strong><\/span><\/p>\n<p><strong>1.\u00a0Online rename and relocation of an active data file:<\/strong><\/p>\n<p>Unlike in the previous releases, a <strong>data file migration<\/strong> or renaming in Oracle database 12c R1 no longer requires a number of steps i.e. putting the tablespace in READ ONLY mode, followed by data file offline action.<br \/>\nIn 12c R1, a data file can be renamed or moved online simply using the <strong>ALTER DATABASE MOVE DATAFILE SQL<\/strong> statement. While the data file is being transferred, the end user can perform queries, DML and DDL tasks. Additionally, data files can be migrated between storages e.g. from non-ASM to ASM and vice versa.<\/p>\n<p><strong>Rename a data file:<\/strong><\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER DATABASE MOVE DATAFILE &#8216;\/u01\/data\/users01.dbf&#8217; TO &#8216;\/u00\/data\/users_01.dbf&#8217;;<\/span><\/p>\n<p>[\/code]<\/p>\n<p><strong>Migrate a data file from non-ASM to ASM:<\/strong><\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER DATABASE MOVE DATAFILE &#8216;\/u01\/data\/users_01.dbf&#8217; TO &#8216;+DG_DATA&#8217;;<\/span><\/p>\n<p>[\/code]<\/p>\n<p><strong>Migrate a data file from one ASM disk group to another:<\/strong><\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER DATABASE MOVE DATAFILE &#8216;+DG_DATA\/DBNAME\/DATAFILE\/users_01.dbf &#8216; TO &#8216;+DG_DATA_02&#8217;;<\/span><\/p>\n<p>[\/code]<\/p>\n<p><strong>Overwrite the data file with the same name, if it exists at the new location:<\/strong><\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER DATABASE MOVE DATAFILE &#8216;\/u00\/data\/users_01.dbf&#8217; TO &#8216;\/u00\/data_new\/users_01.dbf&#8217; REUSE;<\/span><\/p>\n<p>[\/code]<\/p>\n<p><strong>Copy the file to a new location whilst retaining the old copy in the old location:<\/strong><\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER DATABASE MOVE DATAFILE &#8216;\/u00\/data\/users_01.dbf&#8217; TO &#8216;\/u00\/data_new\/users_01.dbf&#8217; KEEP;<\/span><\/p>\n<p>[\/code]<\/p>\n<p>You can monitor the progress while a data file being moved by querying the <strong>v$session_longops<\/strong> dynamic view. Additionally, you can also refer the alert.log of the database where Oracle writes the details about action being taken place.<\/p>\n<p><strong>2.\u00a0Online migration of table partition or sub-partition<\/strong><\/p>\n<p>Migration of a table partition or sub-partition to a different tablespace no longer requires a complex procedure in Oracle 12c R1.<br \/>\nIn a similar way to how a heap (non-partition) table online migration was achieved in the previous releases, a table partition or sub-partition can be moved to a different tablespace online or offline.<\/p>\n<p>When an ONLINE clause is specified, all DML operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. In contrast, no DML operations are allowed if the partition|sub-partition is moved offline.<\/p>\n<p>Here are some working examples:<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name;<\/span><\/p>\n<p>[\/code]<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name UPDATE INDEXES ONLINE;<\/span><\/p>\n<p>[\/code]<\/p>\n<p>The first example is used to move a table partition|sub-partition to a new tablespace offline. The second example moves a table partition\/sub-partitioning online maintaining any local\/global indexes on the table. Additionally, no DML operation will get interrupted when ONLINE clause is mentioned.<\/p>\n<p><strong>Important notes:<\/strong><\/p>\n<ul>\n<li>The UPDATE INDEXES clause will avoid any local\/global indexes going unusable on the table.<\/li>\n<li>Table online migration restriction applies here too.<\/li>\n<li>There will be locking mechanism involved to complete the procedure, also it might leads to performance degradation and can generate huge redo, depending upon the size of the partition, sub-partition.<\/li>\n<\/ul>\n<p><strong>3.\u00a0Invisible columns<\/strong><\/p>\n<p>In Oracle 11g R1, Oracle introduced a couple of good enhancements in the form of invisible indexes and virtual columns. Taking the legacy forward, invisible column concepts has been introduced in Oracle 12c R1. I still remember, in the previous releases, to hide important data \u2013columns from being displayed in the generic queries\u2013 we used to create a view hiding the required information or apply some sort of security conditions.<\/p>\n<p>In 12c R1, you can now have an invisible column in a table. When a column is defined as invisible, the column won\u2019t appear in generic queries, unless the column is explicitly referred to in the SQL statement or condition, or DESCRIBED in the table definition. It is pretty easy to add or modify a column to be invisible and vice versa:<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; CREATE TABLE emp (eno number(6), ename name varchar2(40), sal number(9) INVISIBLE);<\/span><\/p>\n<p>[\/code]<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER TABLE emp MODIFY (sal visible);<\/span><\/p>\n<p>[\/code]<\/p>\n<p>You must explicitly refer to the invisible column name with the INSERT statement to insert the database into invisible columns. A virtual column or partition column can be defined as invisible too. However, temporary tables, external tables and cluster tables won\u2019t support invisible columns.<\/p>\n<p><strong>4.\u00a0Multiple indexes on the same column<\/strong><\/p>\n<p>Pre Oracle 12c, you can\u2019t create multiple indexes either on the same column or set of columns in any form. For example, if you have an index on column {a} or columns {a,b}, you can\u2019t create another index on the same column or set of columns in the same order. In 12c, you can have multiple indexes on the same column or set of columns as long as the index type is different. However, only one type of index is usable\/visible at a given time. In order to test the invisible indexes, you need to set the <strong>optimizer_use_use_invisible_indexes=true<\/strong>.<\/p>\n<p>Here\u2019s an the example:<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; CREATE INDEX emp_ind1 ON EMP(ENO,ENAME); SQL&gt; CREATE BITMAP INDEX emp_ind2 ON EMP(ENO,ENAME) INVISIBLE;<\/span><\/p>\n<p>[\/code]<\/p>\n<p><strong>5.\u00a0DDL logging<\/strong><\/p>\n<p>There was no direction option available to log the DDL action in the previous releases.<br \/>\nIn 12cR1, you can now log the DDL action into xml and log files. This will be very useful to know when the drop or create command was executed and by who. The <strong>ENABLE_DDL_LOGGING<\/strong> initiation parameter must be configured in order to turn on this feature.<br \/>\nThe parameter can be set at the database or session levels. When this parameter is enabled, all DDL commands are logged in an xml and a log file under the <strong>$ORACLE_BASE\/diag\/rdbms\/DBNAME\/log|ddl<\/strong> location. An xml file contains information, such as DDL command, IP address, timestamp etc. This helps to identify when a user or table dropped or when a DDL statement is triggered.<\/p>\n<p>To enable DDL logging<\/p>\n<p>[code language=&#8221;bash&#8221;]<\/p>\n<p><span style=\"color: #000000;\">SQL&gt; ALTER SYSTEM|SESSION SET ENABLE_DDL_LOGGING=TRUE;<\/span><\/p>\n<p>[\/code]<\/p>\n<p>The following DDL statements are likely to be recorded in the xml\/log file:<\/p>\n<ul>\n<li>CREATE|ALTER|DROP|TRUNCATE TABLE<\/li>\n<li>DROP USER<\/li>\n<li>CREATE|ALTER|DROP PACKAGE|FUNCTION|VIEW|SYNONYM|SEQUENCE<\/li>\n<\/ul>\n<p>In <strong>part 2<\/strong>, you will learn more on new changes on <strong>Database Administration, RMAN, High Availability and Performance Tuning<\/strong>\u00a0areas.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>References:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/docs.oracle.com\/database\/121\/NEWFT\/chapter12102.htm#NEWFT003\" target=\"_blank\">https:\/\/docs.oracle.com\/database\/121\/NEWFT\/chapter12102.htm#NEWFT003<\/a><\/li>\n<li><a href=\"http:\/\/education.oracle.com\/pls\/web_prod-plq-dad\/view_pdf?c_org_id=37&amp;c_lang=N&amp;c_id=D79094GC10\" target=\"_blank\">http:\/\/education.oracle.com\/pls\/web_prod-plq-dad\/view_pdf?c_org_id=37&amp;c_lang=N&amp;c_id=D79094GC10<\/a><\/li>\n<\/ul>\n<p>https:\/\/www.youtube.com\/watch?v=2bnYpzMU_u8<\/p>\n<p>https:\/\/www.youtube.com\/watch?v=KSvpYW901Dc<\/p>\n<p>Did you get a chance to download Free Interview Questions related to Database? If not, download it here\u00a0<a href=\"http:\/\/k21academy.com\/oracle-dba-12c-interview-question\">http:\/\/k21academy.com\/oracle-dba-12c-interview-question<\/a><\/p>\n<p><a href=\"http:\/\/k21academy.com\/oracle-dba-12c-interview-question\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-11718\" src=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-1024x154.jpg\" alt=\"Database interview questions\" width=\"1024\" height=\"154\" srcset=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-1024x154.jpg 1024w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-150x23.jpg 150w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-300x45.jpg 300w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-80x12.jpg 80w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-220x33.jpg 220w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-250x38.jpg 250w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-280x42.jpg 280w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-510x77.jpg 510w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-750x113.jpg 750w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-975x146.jpg 975w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010-1190x179.jpg 1190w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/08\/IMG-20170225-WA0010.jpg 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<div style=\"padding: 15px; margin-bottom: 15px; background: #ffffde; border: 1px solid #ddd; width: 100%;\" align=\"center\">\n<h2>Learn Oracle Database 12c \u00a0Administration\u00a0Training<\/h2>\n<p>If you want to learn Oracle Database 12c Administration with tons of additional features like Live Interactive Sessions, Life time access to membership portal, Free re-taking sessions for next one year, Dedicated Machine to practice, On Job Support and much more<\/p>\n<p><a href=\"http:\/\/k21academy.com\/oracle-dba-12c\/\">Click here to\u00a0know more<\/a><\/p>\n<\/div>\n<p>This post is from our <a href=\"http:\/\/k21academy.com\/oracle-dba-12c\/\" target=\"_blank\">Oracle Database 12c Training<\/a>\u00a0where We cover <strong>Architecture, Installation, File System, Backup and Recovery\u00a0<\/strong>and<strong> difference in 12c\u00a0<\/strong>from<strong> previous version <\/strong>with<strong> Hands-On<\/strong>, \u00a0If interested in learning Oracle Database 12c you can Register here for\u00a0<a href=\"http:\/\/k21academy.com\/oracle-dba-12c\/\" target=\"_blank\">Oracle Database 12c Training\u00a0<\/a><\/p>\n<p>&nbsp;<\/p>\n<pre><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This post is series of Oracle Database 12c new features, If you are new to PDB &amp; CDB and challenges [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":10444,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-10398","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Five New Features in Oracle Database 12c for DBAs : Part1 -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Five New Features in Oracle Database 12c for DBAs : Part1 -\" \/>\n<meta property=\"og:description\" content=\"This post is series of Oracle Database 12c new features, If you are new to PDB &amp; CDB and challenges [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-19T08:13:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-12T11:20:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"425\" \/>\n\t<meta property=\"og:image:height\" content=\"171\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/\",\"name\":\"Five New Features in Oracle Database 12c for DBAs : Part1 -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\",\"datePublished\":\"2016-03-19T08:13:38+00:00\",\"dateModified\":\"2017-04-12T11:20:54+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg\",\"width\":425,\"height\":171},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Five New Features in Oracle Database 12c for DBAs : Part1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Five New Features in Oracle Database 12c for DBAs : Part1 -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/","og_locale":"en_US","og_type":"article","og_title":"Five New Features in Oracle Database 12c for DBAs : Part1 -","og_description":"This post is series of Oracle Database 12c new features, If you are new to PDB &amp; CDB and challenges [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/","article_published_time":"2016-03-19T08:13:38+00:00","article_modified_time":"2017-04-12T11:20:54+00:00","og_image":[{"width":425,"height":171,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","type":"image\/jpeg"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/","url":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/","name":"Five New Features in Oracle Database 12c for DBAs : Part1 -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","datePublished":"2016-03-19T08:13:38+00:00","dateModified":"2017-04-12T11:20:54+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2016\/03\/12c_new_features.jpg","width":425,"height":171},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2016\/03\/19\/five-new-features-in-oracle-database-12c-for-dbas-part1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Five New Features in Oracle Database 12c for DBAs : Part1"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/10398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=10398"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/10398\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/10444"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=10398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=10398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=10398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}