Performance Issue - Needs to improve more
Dear Guros,
Following is the time duration when we run Gather Schema & Program Optimizer from compere to old Prod Instance & upgrade Production Instance (Oracle HRMS)
Note: Now we implement Oracle HRMS on this instance & applying some patches.
Our client needs to improve performance from below time frame.
Process | Start time | End time | Total new completion time on EBS server |
Gather Schema Statistics | 12/12/2015 20:18 | 12/13/2015 2:31 | 6 hours |
|
|
| Old completion time on EBS server |
Gather Schema Statistics | 12/9/2015 23:00 | 12/10/2015 3:30 | 4 hours |
|
|
| Total new completion time on EBS server |
Program - Optimizer | 12/13/2015 18:08 | 12/13/2015 18:50 | 42 minutes |
|
|
| Old completion time on EBS server |
Program - Optimizer | 12/11/2015 8:00 | 12/11/2015 8:33 | 33 minutes |
|
|
| Total new completion time on EBS server |