Analyze PeopleSoft Data

You can analyze PeopleSoft data using the features of Oracle Infrastructure Monitoring, Oracle Log Analytics and Oracle Application Performance Monitoring.

Topics:

Analyze PeopleSoft IT Metrics with Infrastructure Monitoring

Oracle Infrastructure Monitoring simplifies monitoring by offering a common set of metrics that enable you to compare the performance across tiers.

You can monitor the status and health across tiers and be alerted about issues, troubleshoot, and resolve them before they affect users. For a typical workflow to use Oracle Infrastructure Monitoring for monitoring the availability and performance of your infrastructure, see Monitor the Availability and Performance of Your Infrastructure in Using Oracle Infrastructure Monitoring.

Oracle Infrastructure Monitoring has the following metrics for a PeopleSoft application and its components:

Monitor status and health across tiers of a PeopleSoft application
Identify and receive alerts on potential issues
Troubleshoot and resolve issues before they negatively impact end users

The following metrics that are available on Oracle Infrastructure Monitoring are grouped by entity type:

PeopleSoft Process Scheduler Domain

Enables batch job scheduling and processing.

General metrics:

Metric Name	Metric Description
Status	Status of the Process Scheduler
Health	Overall health of the Process Scheduler Domain (OK, Warn, Critical)
Load	Overall load of the Process Scheduler Domain (Idle, Light, Medium, Heavy)
Queued Processes for `PSPRCSRV`	Number of queued processes for Process Scheduler (PSPRCSRV)
Queued Processes for `PSDSTSRV`	Number of queued processes for Distribution Server (PSDSTSRV)
Failed Processes	Displays the current number of failed or down server processes within the domain

Metrics for Server Status:

Metric Name	Metric Description
Program Name	Process scheduler program name
Queue Name	Queue Name
Group Name	Group Name
ID	ID
Request Throughput	Requests processed per second since last collection
Load Throughput	Load processed per second since last collection
Status	Status

Metrics for Queue Status:

Metric Name	Metric Description
Program Name	Process scheduler program name
Queue Name	Queue Name
Servers	Servers for the Program Name that are currently running
Queued Processes	Processes that are currently in queue
Machine Name	Machine Name

PeopleSoft Application Server Domain

This entity does all of the complex logic and computations and builds the contents that the web server uses to display pages.

General metrics:

Metric Name	Metric Description
Status	Status of the Application Server
Health	Overall health of the application server domain (OK, Warn, Critical)
Load	Overall load of the application server domain (Idle, Light, Medium, Heavy)
Failed Server Processes	Server processes that have failed or are down within the domain
Memory Usage	Memory used by the application server
State Files	Number of PeopleTools state files generated in the domain logs directory
Tuxedo Connections	Tuxedo Connections

Metrics for Queued Processes:

Metric Name	Metric Description
Queued Processes for Application Server	Number of queued processes for application server
Queued Processes for BRK Dispatcher	Number of queued processes for publication broker dispatcher
Queued Processes for BRK Handler	Number of queued processes for publication broker handler
Queued Processes for PUB Dispatcher	Number of queued processes for publication contractor dispatcher
Queued Processes for PUB Handler	Number of Queued processes for publication contractor handler
Queued Processes for SUB Dispatcher	Number of queued processes for subscription contractor dispatcher
Queued Processes for SUB Handler	Number of queued processes for subscription contractor handler

Metrics for JSH and WSH Performance:

Metric Name	Metric Description
JSH Load Rate	JSHs loaded per second since last collection
JSH Abort Rate	JSH aborts per second since last collection
WSH Load Rate	WSHs loaded per second since last collection
WSH Abort Rate	WSH aborts per second since last collection

Metrics for Service Request Executions:

Metric Name	Metric Description
Service Request Execution Throughput	Service request execution throughput (requests per second) based on last 10 requests
Average Service Request Execution Time	Average service request execution time in milliseconds

Metrics for Client Status:

Metric Name	Metric Description
Row ID	Row identifier counter
Machine Name	Machine Name
User Name	User Name
Client Name	Client Name
Time	Time in seconds that particular user has been active
Status	Current status of the client
Transaction Creation Rate	Transactions created per second since last collection
Transaction Commit Rate	Transactions committed per second since last collection
Transaction Abort Rate	Transactions aborted per second since last collection

Metrics for Server Status:

Metric Name	Metric Description
Program Name	Application server program name
Queue Name	Queue Name
Group Name	Group Name
ID	ID
Request Throughput	Requests processed per second since last collection
Load Throughput	Load processed per second since last collection
Status	Status

Metrics for Queue Status:

Metric Name	Metric Description
Program Name	Application server program name
Queue Name	Queue Name
Servers	Servers for the Program Name that are currently running
Queued Processes	Number of processes that are currently in queue
Machine Name	Machine Name

PeopleSoft Process Monitor

Enables to monitor and submit processes configured to run on a Process Scheduler server.

General metrics:

Metric Name	Metric Description
Status	Status of the Process Monitor

Metrics for Active Distribution State:

Metric Name	Metric Description
Active Distribution State	Active Distribution State
Processes	Number of PeopleSoft processes with an active distribution state value of Processing, Not Posted, Posting or Pending.

Metrics for Distribution Status:

Metric Name	Metric Description
Distribution Status	Process distribution status
Process Distribution Rate	Number of PeopleSoft processes with a distribution status value of Generated or Posted per minute since the last collection

Metrics for Active Run State:

Metric Name	Metric Description
Active Run State	PeopleSoft processes run state
Processes	Number of PeopleSoft processes with an active run state value of Cancel, Hold, Initiated, No Success, Pending, Processing, Queued, Restart or Warning

Metrics for Run Status:

Metric Name	Metric Description
Run Status	PeopleSoft processes run status
Process Run Rate	Number of PeopleSoft processes with a run status value of Cancelled, Error or Success per minute since the last collection

Metrics for Process Metrics Data:

Metric Name	Metric Description
Process Instance	Process Instance
Process Type	Process Type
Process Name	Process Name
User Name	User Name
Creation Date/Time	Creation Date/Time
Scheduled Date/Time	Scheduled Date/Time
Begin Date/Time	Begin Date/Time
End Date/Time	End Date/Time
Run Duration	Run Duration
Run Status	Run Status
Distribution Status	Distribution Status
Run Control ID	Run Control identifier
Server Name	Name of the server

PeopleSoft Pure Internet Architecture

Allows to manage the PIA component. It corresponds to a Web domain in WebLogic.

Metric Name	Metric Description
Status	Status of the PIA
Health	Overall health of the PIA (OK, Warn, Critical)
Load	Overall load of the PIA (Idle, Light, Medium, Heavy)
Wait State Sockets	Web server sockets that are in WAIT state
Fatal Errors	Fatal errors in the JOLTService servlet logs

Analyze PeopleSoft Data Using Log Analytics

Using Oracle Log Analytics, you can reduce millions of log events into a smaller set of patterns. Oracle Log Analytics provides search and analytics capabilities to users through query language or visual builder to obtain useful information and slice and dice through data. It also provides different mechanisms to be proactive about issues through Machine Learning and Alerting capabilities. The following are the some of the tasks that you can perform on Oracle Log Analytics to analyze your log data:

Task	More Information
Visualize data using charts and controls	Visualize Data Using Charts and Controls in Using Oracle Log Analytics
Perform advanced analytics using Link	Perform Advanced Analytics Using Link in Using Oracle Log Analytics
Detect anomalies using outliers	Detect Anomalies Using Outliers in Using Oracle Log Analytics
Perform dynamic log analysis	Perform Dynamic Log Analysis in Using Oracle Log Analytics
Analyze host log trends to proactively monitor infrastructure	Analyzing Host Log Trends to Proactively Monitor Infrastructure ( Tutorial)

Analyze PeopleSoft Data Using Oracle Application Performance Monitoring

Oracle Application Performance Monitoring provides a platform for monitoring and managing your web applications. The following are some of the tasks that you can perform using Oracle Application Performance Monitoring to analyze your PeopleSoft application:

Task	More Information
Isolate and diagnose application performance issues	Isolate and Diagnose Application Performance Issues in Using Oracle Application Performance Monitoring
Gain end-to-end visibility into the performance of your application across all tiers	Monitor Application Performance in Using Oracle Application Performance Monitoring
Troubleshoot end user monitoring	Troubleshoot End User Monitoring in Installing and Configuring Oracle Application Performance Monitoring
Troubleshoot synthetic tests	Troubleshoot Synthetic Tests in Using Oracle Application Performance Monitoring
Drill down to the related logs in context to a problem and find its root cause	Drill Down to Related Logs in Using Oracle Application Performance Monitoring