• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login

Essential Oracle 12c Database New Features

  • Oracle 12cDatabase New Features
  • Oracle 12cSoftware Installations
  • Oracle 12cMultitenant Administration
  • Oracle 12c12c Database on VirtualBox
  • Oracle 12cRAC Administration
ORACLE 12c

Essential Oracle 12c Database New Features

Oracle 12c Multi Tenant Database

Oracle 12c Database: New Features
The Oracle 12c Database has the most new features ever released with any version of any database. As you might have guessed from it’s name, the new version is more focused on Cloud Computing.

Oracle 12c RAC: New Features
Oracle has come a long way from its inception of the 9i RAC database to its current 12c version. I remember the days when we had to deal with RAC related issues, ranging from performance to stability which gradually improved as this product matured. Learn more about the new feature now available with RAC.

Oracle 12c Database: De-Supported & Deprecated Features
While it is important to be familiar with new features of Oracle 12c, it is imporatant to be aware of features which are either being de-supported or deprecated with this database version. Learn more about this important topic.

Oracle 12c Database: Online Table Redefinition and Datafile Movement
Moving objects and datafiles around is required when you need to either change the physical location of the data files or when you want to migrate to ASM or some other Storage system. In Oracle 12c this can be minimized to almost no downtime. Let’s look at how online table redefinition and datafile movement can help us in achieving zero downtime.

Oracle 12c Database Heat Maps and Automatic Data Optimization
When installing Oracle Software, you can create 12c CDB, PDB Databases using OUI, just like you used to do in the previous versions of the Oracle database.

Oracle 12c Last login time for Non-Sys Users
Oracle 12c introduced a new, very useful security feature to store and display the last login information for non-sys users, logging in via SQL*PLUS. The last login time is displayed in the banner by default when we log into the database using SQL*PLUS in 12c.

Manage Multitenant CDB and PDBs with EM Express
Manage Multitenant CDB and PDBs with EM Express. Quick and easy steps to create, setup and deploy EM Express.

Oracle 12c Database: Moving to Multithreaded Configuration
Starting in Oracle 12c database, you can change this and enable the new Multithreaded configuration! And that too by merely setting one parameter. You can change the architecture by making Oracle database use thread based architecture instead of process based. Once changed, all Oracle processes will be threads within a few Oracle processes.

Oracle 12c Database Default Column Value Enhancement
I remember that a number of times, developers have approached me with the question – How do I auto increment a default value in a table column? These were mostly folks who had worked in the MS SQL, Mysql and other database environments where this features exists. Now, Oracle 12c Default Column Value feature has been incorporated and puts this to rest.

Oracle 12c Database Identity Columns
Having a built-in mechanism to populate the identity columns was something that developers have been looking forward to as a feature in the Oracle database. Finally Oracle has finally provided a built-in feature, Oracle 12c Database Identity Columns, to populate these Identity Columns. Let’s look at how you can use this new feature in Oracle 12c.

Oracle 12c Database Multiple Indexes On Same Set of Columns
Oracle database 12c has about 500+ new features when compared to 11gR2. Among these features there will be some which get the mainstream attention. But often little caveats or enhancements prove to be as vital as the big ones. One such enhancement is the ability to have multiple indexes on same column or same set of columns. Lets look at this feature and the possible uses cases.

Oracle 12c DDL Logging in Oracle
By default Oracle database does not log any DDL operations performed by any user. The default settings for auditing only logs DML operations. However that does not mean that you cannot do anything about it. Oracle has provided several ways by which you can track the DDL operations performed on the database. In this article we will look at two of the most common and easy to use ways.

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2021

BLOGOracle Tutorials