Primavera P6v7 performance issue
We have performance issue on Primavera P6v7. The folloiwng is quoted from user's email.
I monitored the database, and captured the queries. On database side, performance is not so bad. More faster than user's claim. So, I think it is client issue. I am DBA, so please help to figure out the issue.
------------------------------------
There has been no noticeable change in the time it takes to close and open all projects in the MPS Data base.(Current Projects Only)
Closing (Current Projects Only) took 4 Minutes and 42 seconds,
Opening (Current Projects Only) took 2 Minutes and 27 seconds,
------------------------------------
Another thing is that I just found out the table PROJWBS has two triggers that will be triggered at the same situation (see below). I haven't read the details that they are logical independents or not. Oracle doesn’t know which one will be triggered first, as Oracle recommended, it is better to combine them into one.