Re: 11gR2 - what patch level?

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • Date: Mon, 05 Jul 2010 20:53:17 +1000

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2010