Re: Performance problem.

-- take a look on BUG 4552415.

Yury, do you have any environment of Apps on AIX?, if so, which kind of
filesystems are you using there?, which mounting options are you using on
your filesystems? what about minservers and maxservers parameters?

Unfortunately I haven't.
I think if the performance problem is Apps slowdown then problem is
generic and isn't connected with particular platform. If you are
saying that there is particular SQL which doing fullcsans on huge
table and by your mind it doesn't suppose to do it, then it is Apps
generic problem.
To deal with this type of problems I would look on Metalink for a
particular report name or log a SR within Oracle Support Services.

I have friends of mine working in telecoms industry  they using AIX as
main platform.
I will forward your questions to them.

Just wonder that is average IO wait time in your system ? If it is
less then 10-5 ms, I would most likely it isn't HW/OS problem, it is
Apps.

Yury

PS Can I ask you to send a perfstat report to me?

Results from quick search throught the Metalink.

We haven't done SQL's tuning process yet, by the way one of the most
"huge" processes scheduled to run like request is report "Inactive Items"
which is embeeded in the application (it is taking 15 minutes to finish),
I have traced this process and it is doing a "FULL" scan of a big table
"MTL_MATERIAL_TRANSACTIONS" (8831854 rows).

4924206 INCIAR: POOR PERFORMANCE OF CREATE AR INTERCOMPANY
4552415 CMCPAW LOW PERFOMANCE IN PERIODIC ACTUAL COST WORKER
"Please indicate why should index MTL_MATERIAL_TRANSACTIONS_N5 be modified?.

(transaction_date, organization_id) for 11.5.10.
.
This specific index was recreated with this order to improve the first
process 1 (Periodic Cost Acquisition Adjustment Processor) which now takes 15
minutes to run against over 3 hours it took previously. If we recreate this
index as you request, process 1 wont be able to use the
MTL_MATERIAL_TRANSACTIONS_N5 on transaction_date index and will be really
slow again. Please indicate if what development needs is to add the
transaction_action_id
columns and if it can be added leaving transaction_date as the first column.
Please indicate why is development changing a standard index."

4719252 PICK SLIP PERFORMANCE WHEN PICK SLIP NUMBER USED
4455311 CSTPDPPC - PERIODIC COST DISTRIBUTIONS PROCESSOR PERFORMANCE ISSUE

Other related posts: