Performance Issue with SSR_CLASS_INSTR Causing High CPU Under Load
(Doc ID 2379295.1)
Last updated on NOVEMBER 23, 2019
Applies to:
PeopleSoft Enterprise CS Student Records - Version 9.2 and laterInformation 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.
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |