OLL Mobile

There are several features in Oracle Database 12c Release 1 of which you can take advantage
when it comes to Data Warehousing and Business Intelligence (BI).

• You can use multipartition maintenance operations which enable adding multiple partitions to a table, dropping multiple partitions, merging multiple partitions into one partition, splitting of a single partition into multiple partitions, and truncating multiple partitions using a single SQL data definition language (DDL) statement.
• You can also recognize patterns in a sequence of rows by using the MATCH_RECOGNIZE clause in native SQL which executes efficiently.
• The new Synchronous Refresh feature will always keep a base table in sync with a Materialized View (MV) that is built on it.
• You can also improve query performance against OLAP cubes.
• Finally, local and global indexes can now be created on a subset of the partitions of a table. This feature provides more flexibility in index creation. Global index maintenance can now be delayed and decoupled using DROP and TRUNCATE partition without making a global index unusable. This new feature provides faster DROP and TRUNCATE partition operations. Index maintenance can be delayed to off-peak time.

Release Date: 06-May-14

Duration: 89 minutes

Credited To: Lauran Serhal

No Flash Plugin Needed

oracle

12-May-14

Lot's of things.. Go thru with high speed. Annoying thing was change of volume between chapters and some chapters had ambient noise of traffic and airplanes behind.