Re: 11gR2 - what patch level?

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: dbvision@xxxxxxxxxxxx
  • Date: Mon, 5 Jul 2010 11:55:36 +0100

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

Other related posts: