RE: 11gR2 - what patch level?
- From: "Go-Faster Consultancy Ltd." <info@xxxxxxxxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, <dbvision@xxxxxxxxxxxx>
- Date: Mon, 5 Jul 2010 22:17:49 +0100
Although I haven't played with this feature in conjunction with PeopleSoft
myself, I don't think it would be a huge problem.
Most of the empty tables in PeopleSoft are PeopleSoft Temporary Records -
these are normal database tables used for temporary working storage by
Application Engine programs. PeopleSoft (since version 8) creates many
identical temporary tables and allocates different tables to different
instances of the same program. It is better than multiple concurrent
processes sharing the same temporary record (and before someone askes they
don't use Global Temporary Tables because they are Oracle specific).
You tend to get the same temporary tables reused repeatedly. You might have
10 copies of a table, but if you only ever run one instance of a program
which uses that table at any one time, then normally you should only ever
access the same temporary table, and you might never access the other 9.
So, you only create the one physical segment.
regards
_________________________
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:david.kurtz@xxxxxxxxxxxxxxx
web: www.go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com
<http://www.psftdba.com/>
DBA Blogs: PeopleSoft: http://blog.psftdba.com <http://blog.psftdba.com/> ,
Oracle: http://blog.go-faster.co.uk <http://blog.go-faster.co.uk/>
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Niall Litchfield
Sent: Monday, July 05, 2010 11:56 AM
To: dbvision@xxxxxxxxxxxx
Cc: oracle-l
Subject: Re: 11gR2 - what patch level?
Importance: High
Hi Noons
I blogged about this one at
http://orawin.info/blog/2010/04/25/new-features-new-defaults-new-side-effect
s/ 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:
