RE: 12c and peoplesoft
- From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
- To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Dec 2014 16:37:46 -0000
There is no direct link between PeopleSoft App version and any version of any
database. Versions of PeopleTools are certified with certain versions of
certain databases, and certain minimum versions of PeopleTools are a
pre-requisite for certain versions of the application (see Oracle support).
Despite being owned by Oracle, PeopleSoft hasn’t moved very far from its
“proudly platform agnostic” heritage – so there is very little in the
application that is specifically optimized for Oracle, let alone a specific
version of Oracle.
There have always been platform advisory notes that make specific
recommendations for specific versions of Oracle (such as setting certain
parameters).
The challenge is around how to manage new database features on Oracle. Of
course that challenge is not unique to PeopleSoft.
Example: statistics management and table preferences in 11g. What should
happen when a batch process collects statistics on a working storage table
(Application Engine and %UpdateStats macro )? Do you want to explicit collect
statistics or rely on dynamic sampling, or combination of both? The content of
the DDL model for the analyse command has changed over time, but it generally
lags behind the options that exist in the database. There have been several
suggestions for what might be better (some on the Oracle support site – some
elsewhere).
PeopleTools 8.54 has a number of new features to support partitioning,
materialized views and global temporary tables – although these would all need
to be customised into the application.
Then on Oracle 12c there are session private statistics for global temporary
tables. How does that change the game?
I offer no answers because “it depends” If you don’t have a performance
problem, then you don’t need to do anything. If you do, you have new options
that you can bring to bear.
Ram said he was on 10g and considering 11g –v- 12c . 10g is already well out
of support, it won’t be that long until 11g goes into extended support (cost
option). Subject to the PeopleTools version, I would have thought that that
alone would make going from 10 to 12 in one step more attractive than taking
two steps via 11g.
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 Powell, Mark
Sent: 15 December 2014 15:08
To: oracle-l
Subject: RE: 12c and peoplesoft
Importance: High
I would suggest you match the Peoplesoft Application to the version of Oracle
that the Peoplesoft Application software says it supports even if that means
using an older version of Oracle. If the Peoplesoft guide says it will run on
11.2 or 12.1 that is great but run on the version it specifies.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ram K
Sent: Saturday, December 13, 2014 12:23 AM
To: oracle-l
Subject: 12c and peoplesoft
List
We are considering moving our peoplesoft suite of ERPs (fin,hr,etc..) to 9.2.
They currently run on oracle 10.2. As part of the upgrade we are considering
oracle 11.2 or 12.1 for DB.
Any listers here have that combination or recently moved to one can share their
experiences on the performance/results after the move, the good and the bad.
--
Thanks,
Ram.
Other related posts:
