12.1.0.2

12.1.0.2 Multitenant Database New Features

Heres a quick look at some of the new features introduced in 12.1.0.2 around Pluggable and Container databases. PDB CONTAINERS Clause Using the CONTAINERS clause, from the root container we can issue a query which selects or aggregates data across multiple pluggable databases. For example each pluggable data can contain data for a specific geographic […]

Exadata Storage Index Min/Max Optimization

Before discussing the Exadata-specific feature, let’s review what the database engine can do independently of whether Exadata is used. To execute queries containing the min or max functions efficiently, two specific operations are available with B-tree indexes defined on the column referenced in the min or max function. The first, INDEX FULL SCAN (MIN/MAX), is […]

Oracle 12c New Features—In Memory Option(1)

本站文章除注明转载外,均为本站原创: 转载自love wife & love life —Roger 的Oracle技术博客 本文链接地址: Oracle 12c New Features—In Memory Option(1) Oracle 12.1.0.2版本了引入了一个非常牛叉的功能,即In Memory option,这是十分具有诱惑力的,针对这个重大的变化,我会进行一个系列文章的分析,这是第一篇。 首先,我们来尝试下In Memory option功能。 [oracle@ora12012 ~]$ sqlplus “/as sysdba” SQL*Plus: Release 12.1.0.2.0 Beta on Tue Jul 29 05:30:26 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – […]

The Importance of the In-Memory DUPLICATE Clause for a RAC System

With the INMEMORY clause you can specify 4 sub-clauses: The MEMCOMPRESS clause specifies whether and how compression is used The PRIORITY clause specifies the priority (“order”) in which the segments are loaded when the IMCS is populated The DISTRIBUTE clause specifies how data is distributed across RAC instances The DUPLICATE clause specifies whether and how […]

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569