Re: PeopleSoft Performance on Oracle 10.2.0.2
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: breitliw@xxxxxxxxxxxxx
- Date: Tue, 27 Feb 2007 15:35:52 -0800 (PST)
its called runstats in 8.48 and leverages dbms_stats.
There were also the following notes..
Oracle 10gR2
Version 10.2.0.2.0
For customers using Oracle 10gR2 (10.2.0.2.0), Patch bundle 5381980 is now
available for all supported Unix platforms. For Windows platform specific
patches, please see the bottom of this section.
Patch bundle# 5381980 addresses all of the bug issues discovered while testing
with Oracle 10gR2 (10.2.0.1.0).
The patch bundle alleviates the need for the previously documented required
'workaround' init.ora parameters:
_optimizer_cost_ based_transformation=off
_disable_function_based_index=true
Once the patch is installed, remove the preceding init.ora parameters before
bringing up your DB SIDS.
This Oracle patch bundle# 5381980 consists of the following bug fixes and is
available on all the platforms we GA'd on except for Windows. The Windows
platform patch will be available shortly.
#----------------------------------------------------------------------
# Interim Patch for Base Bugs: 5381980 5109749 5227899 4900129 5092688 4939157
#----------------------------------------------------------------------
#
# Bugs Fixed by this patch:
# -------------------------
# 5381980:MLR FOR THE FIXES IN 5227899 AND 5109749 ON TOP OF 10.2.0.2
# 5109749:SQL STATEMENT THAT PREVIOUSLY WORKED ON ORACLE 10.1/9.2 RETURNS 0
ROWS ON 10GR2
# 5227899:MERGE LABEL REQUEST ON TOP OF 10.2.0.1 FOR BUGS 4939157 5092688
4900129
# 4900129:HIGH CPU CONSUMPTION AND ELAPSED TIMES FOR ALTER TABLE MODIFY
# 5092688:SQL EXECUTION REGRESSION RETURNING INCORRECT# OF ROWS ON 10.2.0.1.0
# 4939157:ORA-07445 [EVAOPN2()+209] WITH A FUNCTIONAL-INDEX
-----------------------------------------------------------------------
Windows platform specific patch bundles are available but the patch number
varies based on platform:
For ORACLE on
10gR2 10.2.0.2 WINDOWS 32 BIT
use Patch# 5502226
For ORACLE on
10gR2 10.2.0.2 WINDOWS-64 XP AND 2003 -64BIT
use Patch# 5500894
For ORACLE on
10gR2 10.2.0.2 WINDOWS-64 AMD64 AND INTEL EM64T XP AND 2003 -64BIT
use Patch# 5500921
-----------------------------------------------------------------------
All of the aforementioned patches will be rolled into the next available
patchset 10.2.0.3.0.
Patch# 5381980 is a cumulative patch bundle comprised of the following
required, one-off patches:
Patch# 5109749 addresses issues of incorrect numbers of rows returned when
queries are utilizing desc indexes.
In some cases ORA-01428: argument 'c20438' is out of range" was being returned.
Patch# 4900129 addresses performance issues specifically related to the PT8.48
Datatype conversion process.
Patch# 5092688 addresses issues of incorrect numbers of rows returned when
queries are utilizing desc indexes.
Patch# 4939157 addresses ORA-00600 and ORA-07445 dumps being generated on
queries are utilizing desc indexes.
Additional required patches:
Patch# 4768040 addresses performance issues where the SELECT portion of an
INSERT SELECT statement runs fast but the actual INSERT runs very slow. This
issue was reported in the field as bug# 5014836.
The base bug# is 4768040.
Note: The base bug#4768040 has been ported to Oracle 10.2.0.2.0 for all
supported platforms.
Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
What "ptools stats collection script" do you mean. I hope not updstats.sql?
I haven't seen 8.48 yet so I don't know what it comes with.
At 12:18 PM 2/26/2007, Job Miller wrote:
>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.
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
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Have a burning question? Go to Yahoo! Answers and get answers from real people
who know.
Other related posts:
