My Oracle Support Banner

Performance Issue with SSR_CLASS_INSTR Causing High CPU Under Load (Doc ID 2379295.1)

Last updated on MARCH 27, 2018

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Student Records Self Service Performance issue

ACTUAL BEHAVIOR
---------------
There is a performance issue with the following select statement that is causing high CPU and performance issues with student self service under load:

SELECT FILL.CRSE_ID,FILL.CRSE_OFFER_NBR,FILL.STRM,FILL.SESSION_CODE,FILL.CLASS_SECTION,FILL.CLASS_MTG_NBR,FILL.EMPLID,FILL.INSTR_ROLE,FILL.SCHED_PRINT_INSTR, FILL.NAME_DISPLAY,FILL.LAST_NAME, FILL.FIRST_NAME FROM PS_SSR_CLASS_INSTR FILL WHERE CRSE_ID=:1 AND CRSE_OFFER_NBR=:2 AND STRM=:3 AND SESSION_CODE=:4 AND CLASS_SECTION=:5 AND CLASS_MTG_NBR=:6 AND SCHED_PRINT_INSTR='Y'

EXPECTED BEHAVIOR
-----------------------
Expect the sql statement, which displays instructors for class search results, to execute in an efficient manner.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Many students using class search and enrollment. 

Cause

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

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

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