Home Screen Performance Issue
We are running Agile PLM version 9.3.6, WebLogic 12.1.2, Windows server 2012, separate APP and SQL servers. We are experiencing a performance issue regarding the load of the home screen – taking 1-2 mins upon login and when returning to the home screen for both the “workflow” and “My Assignments” tab. Once on the home screen and have engaged both of these tabs – they respond very quickly when toggling between them. However once you leave the home screen and attempt to return to it, you are again subject to a very slow response to both of these tab views until them are both viewed once.
Other PLM system functions have no performance issues.
There does not seem to be any server performance issue (CPU, disk, memory) to account for this specific system performance issue. Our PLM system typically will have between 20-30 active users and the issues.
Any suggestions or know system patch to resolve this home page performance issue? We are opening a case with Oracle support but I thought I would as this group also.
How many notifications are there? I’ve seen this happen when there are 1000s of notifications on the home page.
There does seem to be a relationship here in that the response will be faster (but not acceptable) if the “pending” option is changes from All to 30 days. I do not think anyone is in the 1000+ range. For my case it is around 170 pending notifications.
Hello
It could be because there are too many records in the notification_fields table. So, even though the user has less notifications, it is taking lot of time to show what the user has. Probably, you need to clean some old read records
Please refer to this metalink article and it has some pointers
Here is a snippet
<<
This document provides SQL scripts for deleting read notifications by all read notifications, a specific user’s read notifications, or notifications received in a specific time frame. In addition to clearing out notifications, these scripts can provide relief from performance symptoms related to excessive undeleted notifications
>
Hope this helps
-Raj