Class Roster performance poor after applying CS Bundle #34

(Doc ID 2063645.1)

Last updated on NOVEMBER 01, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9 [Release 9]
Information in this document applies to any platform.


After applying CS 9.0 Bundle #34, customers have noted a significant decrease in performance of the Class Roster and Grade Roster components. In particular, CLASS_ROSTER_VW view is consuming excessive amounts of CPU.

DB Platform: Generic
Tools Version: 8.53.12+
Application & Version: PeopleSoft Enterprise Campus Solutions 9 Bundle 34 and beyond
The issue can be reproduced with the following steps:
1. Attempt to view a class roster that lists more than 100 students. Note the time to load into the component prior and after applying CS Bundle #34.
Customers are finding some class rosters will not load at all. Where rosters load, the load is so slow that faculty and users are unable to make use of the Class Roster functionality.


 Problem occurs after applying CS Bundle #34.


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 hundreds of Community platforms