PeopleSoft Performance Gains on Exalogic & Exadata

Here are the results of a PeopleSoft HCM performance comparison I ran between Exalogic-Exadata and a Dell-EMC infrastructure.

PeopleSoft Details

PeopleSoft HCM 9.0, PeopleTools 8.52.09, WebLogic 10.3.6, Tuxedo 10.3, Oracle 2 Node 11gR2 RAC DB

The PeopleSoft HCM database was copied over to Exadata using a backup, all database parameters were kept the same and there was no SQL tuning.

The custom PS_HOME along with the web server, application server and process scheduler configurations were copied over to Exalogic.

Dell-EMC (Red Hat Enterprise Linux 5)

Web Tier: PowerEdge M610 (VMware) - 8 VMs each with 2 Cores and 4GB RAM

App Tier: PowerEdge M610 (VMware) - 10 VMs each with 4 Cores and 16GB RAM

Batch Tier: PowerEdge M610 (VMware) - 2 VMs each with 4 Cores and 16GB RAM

DB Tier: 2 – PowerEdge M905 - 16 Cores and 32GB RAM

Storage Tier: EMC CX4-480

Engineered Systems (Oracle Enterprise Linux 5)

Web/App/Batch Tier: Exalogic X4-2 Quarter Rack (OVM) - 1 VM created with 8 Cores and 32GB RAM

DB/Storage Tier: Exadata X4-2 Quarter Rack with 2 Compute Nodes each with 24 Cores and 256GB RAM

The following performance gains may vary for each customer and is dependent on a number of factors including the amount of data, number of users, PeopleSoft customizations and the existing hardware platform. While the existing hardware in this test is dated, we oftentimes see similar, significant performance gains against the latest commodity server and storage hardware as well.  These gains are a result of the ‘special sauce’ (i.e. optimizations) in Oracle’s Engineered Systems products.

PeopleSoft Test Case

Dell/EMC

Exalogic/Exadata

Performance Gain

Labor Distribution Report

9 Minutes

15 Seconds

36X

Advice Print Job

106 Minutes

11.5 Minutes

9.2X

Update Large Employee Record

9.5 Minutes

25 Seconds

22.8X

Update Employee Address

1 Minute 45 Secs

20 Seconds

5.3X

Benefits Data Refresh

32 Minutes

10 Minutes

3.2X

Database Backup

205 Minutes

60 Minutes

3.4X

The above results were completed with no Engineered Systems tuning, so even with these high X factors there is still room for bigger performance gains

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Phil Wang-Oracle

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today