Re: share a new 11gR2 feature

From: Shaun Batterton <>
Date: Thu, 3 Sep 2009 11:28:09 -0400
Message-ID: <>

WITH RECURSIVE, demonstrated as a solution to NOCOUG's sql challenge:

Instance Caging is interesting. The documentation explains two different approaches for managing cpu allocations, over-provisioning and partitioning, but it isn't clear how to implement those approaches. Will Oracle change cpu licensing requirements if you limit all instances to N cpus? Unlikely, I suppose. DBMS_PARALLEL_EXECUTE should eliminate the need for DIY parallelism.
The scheduler's new features for file watching events and email notification should be helpful.

Received on Thu Sep 03 2009 - 10:28:09 CDT

Original text of this message