on 01-31-2013 3:13 PM
Dear Team,
Am facing some performance issue in SCM/APO system. Previously all jobs are finished with in 200 to 500 sec , since last few days, all these jobs are running for long time(5000 to 7000sec) and finished successfully.But user are complaining about these jobs. I didn't find any logs,other than job logs in sm37.
If anyone has come across the same issue, please provide your inputs on this.
system looks fine...but still jobs are taking long time to finish.
Thanks in advance.
Regards,
Venkat
Hi,
Please check whether any DB activity has been carried out for the tables you are facing the issues. What is the size of the table that is taking long time. You can get a help of ABAPer to see the tables that are used.
You can try the following.
1. Run oracle update stats and make sure that your oracle is up to date.
2. create indexes for the tables that are running for long time
3. Try to update the kernel to latest level . If you are using 701 kernel, you can upgrade to 720 and check.
Please check and provide your feedback.
Thanks and Regards
Vimal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.