Hi Noons I blogged about this one at http://orawin.info/blog/2010/04/25/new-features-new-defaults-new-side-effects/ it's an init parameter to turn off/on. I'm pretty certain however since I blogged that that for the "import into SE" doesn't work case setting TRANSFORM=SEGEMENT_ATTRIBUTES:n will work should you need it. Liukely not for ps databases. On Mon, Jul 5, 2010 at 11:53 AM, Nuno Souto <dbvision@xxxxxxxxxxxx> wrote: > Thanks heaps, folks. > Any way of turning off the deferred segment creation? > It won't affect our DW but the Peoplesoft dbs could be a problem, with > their thousands of empty tables. > > -- > Cheers > Nuno Souto > in cold Sydney, Australia > dbvision@xxxxxxxxxxxx > > > fairlie rego wrote,on my timestamp of 5/07/2010 8:36 PM: > >> * On all my 11.2 database I have set the RM plan to null >> >> >> alter system set resource_manager_plan='' scope=both sid='*'; >> as mentioned in >> http://www.oaktable.net/content/resource-manager-and-11g >> Without this I have seen sessions going into resmgr: cpu quantum for no >> reason at all. >> >> * Also seen some issues with deferred segment creation which is now >> TRUE by default >> >> Thanks >> >> >> *Fairlie Rego >> *Senior Oracle Consultant >> http://el-caro.blogspot.com/ >> M: +61 402 792 405 >> >> >> --- On *Mon, 5/7/10, Peter Hitchman /<pjhoraclel@xxxxxxxxx>/* wrote: >> >> >> From: Peter Hitchman <pjhoraclel@xxxxxxxxx> >> Subject: Re: 11gR2 - what patch level? >> To: "oracle-l" <oracle-l@xxxxxxxxxxxxx> >> Received: Monday, 5 July, 2010, 8:01 PM >> >> Hi Nuno, >> Got any pointers on MOS or elsewhere about what to do about the >> resource manager? We do not use it, so the last thing I want is it >> switched on with default settings. >> >> Thanks >> Pete >> > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info