07-19-2009 8:01 AM
Hi folum exerts,
Can you provide any solutions or hints for poor performance during remoeving ERP6.0 SPS12 client?
Now, I am experiencing very long processing VBFA with very low IO.
The table contains 760K entries for each of the existing clients.
Meantime, one of them are to be removed.
6.5 hours after starting client deletion using transaction SCC5, VBFA is being removed.
Now, 10 hours later, VBFA is still subject for removal.
there are almost no I/O, except for small number of DirectRead/Sequential Read.
during this, once the client copy has been cancelled intentionally to have VBFA table updated is statistic.
and, restarted -- actually, it's rerun --
ERP6.0 SPS12
Oracle 10.2.0.4
Sun Solaris 10
Any advice should be gread helful.
thanks in advance,
Kohji
07-19-2009 4:43 PM
You should post your question to or . I guess there are some Oracle possibilities like fast deleting, delay index rebuild, etc. (I don't know but I hope this is possible... for you, good luck )
07-19-2009 4:43 PM
You should post your question to or . I guess there are some Oracle possibilities like fast deleting, delay index rebuild, etc. (I don't know but I hope this is possible... for you, good luck )