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

Latest Articles

Real-Time Database Operation Monitoring in Oracle Database 12c Release 1
Oracle 12c extends real-time SQL monitoring to allow monitoring of multiple SQL and PL/SQL calls as a single operation.

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.

Latest Oracle Technology Network News

Real Time Analytics with GoldenGate and Oracle BI Applications - Oracle ACE Christian Screen sets the bar high with this excellent Business Intelligence tech tip delivered in record-setting time. (Mon, 18 May 2015 21:07:15 +0000)

Video: Migrating Oracle FDM Mappings to FDME - Infratects solution architect and Oracle APM integration specialist Francisco Amores runs out the clock with his 2 Minute Tech Tip on migrating Oracle FDM mappings to FMDE. (Mon, 18 May 2015 21:05:18 +0000)

Video: Bringing Maps to Data - interRel senior consultant Wayne van Sluys knows exactly where he is -- and who he is -- in this 2 Minute Tech Tip devoted to maps, data, spatial analytics, and business intelligence. (Mon, 18 May 2015 21:03:25 +0000)

Podcast: Cloud at Collab 2015 - A Roundtable Discussion - Members of the IOUG Cloud Computing SIG and people behind the Collab 2015 Cloud track discuss how cloud has evolved in the real world, and how that evolution was reflected in both the sessions and the informal conversations at Collab 2015. (Wed, 13 May 2015 18:06:30 +0000)

Oracle BI Applications 11g: GoldenGate Integration - Oracle ACE Michael Rainey's technical article walks you through we'll walk through the architecture and setup for using GoldenGate 11g with Oracle BI Applications (Tue, 21 Apr 2015 20:35:26 +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 speaking 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