10 Interesting Things about Oracle 12c

admin Database

  • 1 – Multitenant Architecture: Introducing container databases (CDB) allows zero, one or many pluggable databases. These pluggable DB’s can be customized specific to applications. So, instead of having multiple DB’s architected differently, you have a CDB, which contains all user information, than custom database that access through single root.
  • 2 – Oracle Data Pump Export a View as a Table: DBA can export a view, which exports the definition and the actual data. Upon import a table is created using the view definition and the data exported for the view is imported into this table.
  • 3 – Oracle Data Pump ‘No Logging’ Option for Import: Enabling this option speed up imports and limit redo logging during an import.
  • 4 – Enhanced DDL Operations: that no longer require blocking lock operations. Example: Drop Index Online
  • 5 – Move a Data File Online
  • 6 – Enterprise Manager Database Express: Extremely lightweight web based tool to manage Oracle databases. Replaces DBConsole, which used to require startup of a web application tier.
  • 7 – PGA Size Limit: An instance can allocate more memory for PGA than is specified in PGA_AGGREGATE_TARGET. A new parameter, PGA_AGGREGATE_LIMIT, puts hard limit on the total amount of PGA that can be allocated to an instance.
  • 8 – Oracle Flex ASM: Removes the requirement to have one and only one ASM instance per cluster node. Not all nodes in a RAC cluster must have an ASM instance running.
  • 9 – varchar2 size limit: Increased from 4,000 to 32,767 bytes.
  • 10 – Identity Column: This tool allows the ability to define an identity clause against a column using a numeric type. Instead of creating a primary key numeric column and using an Oracle Sequence to populate this column, the identity column populates the column automatically when inserting a new row into the table.