On 10 December 2015 I’ll give an online training entitled Oracle Database 12c – New Performance Features. This short post provides key information about it. Description With every new release of Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that 12.1 is no exception to the rule. […]
Heres a quick look at some of the new features introduced in 220.127.116.11 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 […]
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 […]
I have recently tested the upgrade to RAC Grid Infrastructure 18.104.22.168 on my test RAC Oracle Virtualbox Linux 6.5 x86-64 environment.
The upgrade went very smoothly but we have to take a few things into account – some things have changed in 12.1….
Oracle Grid Infrastructure 12c uses a considerable amount of RAM and CPU resources; here are a few tips to shoehorn it into a 2GB virtual machine.
本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客 本文链接地址: Oracle 12c New Features—In Memory Option(1) Oracle 22.214.171.124版本了引入了一个非常牛叉的功能，即In Memory option，这是十分具有诱惑力的，针对这个重大的变化，我会进行一个系列文章的分析，这是第一篇。 首先，我们来尝试下In Memory option功能。 [oracle@ora12012 ~]$ sqlplus “/as sysdba” SQL*Plus: Release 126.96.36.199.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 188.8.131.52.0 – […]
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 […]
The aim of this post is not to explain how the APPROX_COUNT_DISTINCT function works (you find basic information in the documentation and in this post written by Luca Canali), but to show you the results of a test case I run to assess how well it works. Here’s what I did… I created a table […]
I recently upgraded EM 12c version 184.108.40.206 to EM 12c Release 2 (220.127.116.11) on a Linux 64 bit platform. Here are few of the things to keep in mind and some notes I made which may be helpful to others planning the similar upgrade.
The 12c Release 2 softw…