Re: PeopleSoft Performance on Oracle 10.2.0.2

From: Job Miller <jobmiller_at_yahoo.com>
Date: Mon, 26 Feb 2007 11:18:33 -0800 (PST)
Message-ID: <20070226191833.13125.qmail@web53904.mail.yahoo.com>

turn off the auto stats collection job in 10g, and use the supplied ptools stats collection script. That being said though, I *think* the supplied stats collection script for 10g comes with the 8.48 tools release. that tools stats collection script though should be applicable to your environment regardless of your tools release.

Job

Parvez Bashir <pbashir_at_hotmail.com> wrote: Many thanks for making us aware. We are not running system stats on the 9i version.

Regards,
Parvez

>From: Wolfgang Breitling

>To: pbashir_at_hotmail.com
>CC: oracle-l_at_freelists.org
>Subject: Re: PeopleSoft Performance on Oracle 10.2.0.2 Date: Fri, 23 Feb
>2007 12:50:33 -0700
>
>Did you run Oracle 9.2.0.5 with system statistics. If not, that could be a
>bit of a shock when you upgrade as 10g will use system statistics (unless
>you set some _ initialization parameter).
>In general it should be positive but there is always an exception to any
>rule.
>
>At 11:03 AM 2/23/2007, Parvez Bashir wrote:
>>Hi All,
>>
>>We are uprading our PeopleSoft environment this weekend from Oracle
>>9.2.0.5 to Oracle 10.2.0.2 (with DST and Oct CPU patches) on Aix 5.3. The
>>PeopleTools will also be upgraded to PeopleTools version 8.22.14?
>>
>>Any advice on performance/optimizer related settings?
>
>Regards
>
>Wolfgang Breitling
>Centrex Consulting Corporation
>www.centrexcc.com
>
>______________________________________________________________________
>This email has been scanned by the MessageLabs Email Security System.
>For more information please visit http://www.messagelabs.com/email
>______________________________________________________________________

Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117

--
http://www.freelists.org/webpage/oracle-l




 
---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 26 2007 - 13:18:33 CST