Re: share a new 11gR2 feature
From: Shaun Batterton <shaun.batterton_at_gmail.com>
Date: Thu, 3 Sep 2009 11:28:09 -0400
Message-ID: <81d313ef0909030828q68564ec8x4949c52d7d4b40a2_at_mail.gmail.com>
WITH RECURSIVE, demonstrated as a solution to NOCOUG's sql challenge: http://hype-free.blogspot.com/2009/04/nocoug-sql-challenge.html
Date: Thu, 3 Sep 2009 11:28:09 -0400
Message-ID: <81d313ef0909030828q68564ec8x4949c52d7d4b40a2_at_mail.gmail.com>
WITH RECURSIVE, demonstrated as a solution to NOCOUG's sql challenge: http://hype-free.blogspot.com/2009/04/nocoug-sql-challenge.html
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 03 2009 - 10:28:09 CDT