8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Latest Articles

Multiple Indexes on the Same Set of Columns in Oracle Database 12c Release 1
Oracle 12c allows multiple indexes on the same set of columns, provided only one index is visible and all indexes are different in some way.

Administrative Privileges and Job Role Separation in Oracle Database 12c Release 1 (12.1)
Oracle 12c includes additional administrative privileges to allow a greater level of job role separation if that is necessary in your organisation.

Partitioning Enhancements in Oracle Database 12c Release 1 (12.1)
This article brings together all the articles related to partitioning enhancements in Oracle Database 12c Release 1.

Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1
In Oracle 12c some maintenance operations can now be performed on multiple partitions in a single ALTER TABLE statement.

Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1
Oracle 12c allows the creation of global and local indexes on a subset of the partitions of a partitioned table.

Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1
In Oracle 12c it is now possible to move table partitions and sub-partitions as online operations.

Interval-Reference Partitioning in Oracle Database 12c Release 1
Oracle 12c allows you to use an interval partitioned table as the parent for a reference partitioned table.

Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1
The TRUNCATE [SUB]PARTITION and EXCHANGE [SUB]PARTITION commands can now include a CASCADE clause, allowing the actions to cascade down the hierarchy of reference partitioned tables.

Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1
Oracle 12c can optimize the performance of some DROP PARTITION and TRUNCATE PARTITION commands by deferring the associated index maintenance, while leaving the global indexes in a valid state.

Resource Manager Enhancements in Oracle Database 12c Release 1 (12.1)
This article describes the enhancements to automatic consumer group switching in Oracle 12c Release 1 (12.1).

Latest Oracle Technology Network News

Podcast: Docker and Virtualization - The latest OTN ArchBeat Podcast series features a four-part discussion of Docker and Virtualization. The panelists include Oracle Fusion Middleware architects Mark Nelson, Edwin Biemond, and Jim Clark, Oracle ACE Director and Fusion Middleware expert Lucas Jellema, CTO of AMIS Services, and Rubicon Red co-founder and CTO Matt Wright, a recognized expert in Oracle SOA and BPM. (Thu, 16 Apr 2015 17:09:02 +0000)

Optimize ADF Faces Pages for Printing - ADF Faces tables that use percentage values to define the column widths, paired with column stretching set to "multiple", don't display well in print mode. Stefanie Schwiesow's article outlines a solution to beautify the prints of ADF Faces tables in Oracle JDeveloper 12c, allowing developers to still define table column widths as a percentage. (Thu, 16 Apr 2015 17:03:39 +0000)

Tame Big Data using Oracle Data Integration - Hands On Lab: move and transform all your data using Oracle Data Integration - whether that data resides in Oracle Database, Hadoop, third-party databases, applications, files, or a combination of these sources. (Mon, 30 Mar 2015 15:58:11 +0000)

Oracle Big Data Lite 4.1.0 is available with more on Oracle GoldenGate and Oracle Data Integrator (Data Integration) - Overview of Big Data technology set from Oracle, featuring new updates to Oracle Data Integrator and the recently released Oracle Goldengate for Big Data. (Mon, 30 Mar 2015 15:59:12 +0000)

Part 8 - Mirroring the ZFS Root Pool | Oracle Community - Part 8 of a series that describes the key features of ZFS in Oracle Solaris 11.1 and provides step-by-step procedures explaining how to use them. This article focuses on how to mirror the ZFS root pool to minimize the risk of data loss. (Fri, 27 Mar 2015 15:25:22 +0000)

Site News

UKOUG System Event
I'm speaking at the UKOUG System Event on May 20th. See you there.

Multitenant Articles
All articles related to the multitenant option are linked from an overview article here.

Public Speaking Tips
You can read my series of blog posts on public Sepeaking Tips here.

You can follow me on these networks:

Get the T-Shirt
You can get an oracle-base.com t-shirt here.

Search Errors

8i R3  
9i R1 9i R2
10g R1 10g R2
11g R1 11g R2
12c R1  
Search Docs

8i R3  
9i R1 9i R2
10g R1 10g R2
11g R1 11g R2
12c R1  

Oracle Documentation

8i R3, 9i R1, 9i R2
10g R1, 10g R2, 11g R1, 11g R2
12c R1
EM 10g, EM 11g, EM 12c
AS10g R2, AS10g R3,
FMW 11gR1, FMW 12cR1, FMW 12cR2
Oracle VM, VirtualBox

Technology Centers

BI and DW, Cloud, Embedded, Java, Linux, Mac OS X, .NET, PHP, PL/SQL, Scripting Languages, Security, SOA, Virtualization

Oracle Resources

Technology Network, Oracle Support, Oracle Certification, Oracle Magazine, Ask Tom, Oracle Wiki, Products, Downloads, Documentation, Forums, VirtualBox, VirtualBox Developer VMs, CPUs & PSUs