yxes2013 wrote:Ask the users for more details about the transfer process and see what they mean by it. It is a concurrent program, you can enable trace and generate the TKPROF file.
The users told me that they encounter slowness in the performance when the do the "transfer" process. I do not know what program is being run in this process. Can this be caught in the
Base on your experiences on GL Transfer, what usually caused this program to go slow?, that also affected all users per se.Please see the following notes, first test them on test instance.
yxes2013 wrote:Please generate the TKPROF file and upload the file to any free hosting website and post the link here.
Is TKPROF different or better from Statspack? Has there EBS notes that recommends Statspack monitoring?
Base on your experiences on GL Transfer, what usually caused this program to go slow?, that also affected all users per se.
yxes2013 wrote:What is the note you are referring to?
Thanks a lot,
Maybe I still have to verify with the users, what is the specific type of GL Transfer, because there are lots of kinds in the notes.
I hope I will fall to this one >
+*<Moderator Edit - deleted MOS Doc content - pl do NOT post such content - it is a violation of your Support agreement>*+
Is this one still applicable?Yes.
FAQ: Common Tracing Techniques in Oracle E-Business Applications 11i and R12 [ID 296559.1]
How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1]
yxes2013 wrote:Please see (How To Setup AutoInvoice For Optimal Performance [ID 1083467.1]).
Hi again hussein,
BaseD on Statspack, the performance issue seems caused by I/O contention and undo/rollback issue. It seems that the the disk can not handle lots of process being run against it.
Is it possible to schedule autoinvoice by segment? Instead of running 20 concurrent request simultaneously, I will run 1 by 1 till it finished. I really do not understand how autoInvoice works.
Do I still need to run TKPROF? Does tfprof shows I/O, cpu, memory contentions?Yes.
Is this related to your other posts?Yes, but you are not answering there :(
Yes, but you are not answering there :(You should not create duplicate posts and if you still have a question related to this thread you should post it here.
If I increase my redo logs size to 100Mb each, do I need to run autoconfig?No.
Our database now is 184.108.40.206 , if I apply patch 220.127.116.11 do I need to run autoconfig too? Can you give me metalink notes on how to apply 18.104.22.168 patch for EBS database?Yes -- Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0) [ID 216550.1]
My database cache size is 288M , does it seems small? Can you tell me what is your db cache size?It depends on how data you have and the size of the database is not related to the issue you have.