My Oracle Support Banner

E-ORA: Advice for the Oracle DBA in Supporting PeopleSoft Applications (Doc ID 1445965.1)

Last updated on APRIL 17, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.55 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.56 to 8.56 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.57 to 8.57 [Release 8.4]
PeopleSoft Enterprise PT PeopleTools - Version 8.58 to 8.58 [Release 8.4]
Information in this document applies to any platform.


This document is intended for the Oracle DBA who seeks a "big picture understanding" regarding how to support a PeopleSoft Application. It is a brief overview that contains advice from PeopleSoft Support Install/Upgrade and CoE teams with links to relevant KM documents.

It is organized as a series of steps starting with comments related to hardware, and working "up" from there, e.g. from hardware, operating systems, database versions and patchsets, initialization settings, statistics, and so on.

This document was written with the anticipation that the reader is an Oracle DBA that is skilled in the various aspects of implementation, administration, and tuning of the Oracle RDBMS. Additionally, it will be helpful for the reader to be fluent in PeopleSoft technologies and/or have access to PeopleSoft technical staff that can modify settings to meet specific implementation needs.

The information contained in this document applies to Oracle databases used for PeopleSoft Applications built on PeopleTools 8.50+, specifically on Oracle 10g, through 12c.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.