Posting Ledger

[Roshan]

       
Hi,

There is 1 Posting Ledger which contains 7142 lines. It takes 3-4 hours to complete. Can you please suggest what shall we do to make this Posting run faster?

Is there some tuning we need to do?

Regards,
Roshan

[ErmanArslansOracleBlog]

Check its database session and see its waits. According to the waits, thinkk about tuning areas.
Also check oracle support for performance patches and recommendations using the name of the activity ( posting ledger in this case)
Lastly , talk with the functional team of yours and ensure that they are doing the right things.

3 Ağu 2016 14:12 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

       
Hi,

There is 1 Posting Ledger which contains 7142 lines. It takes 3-4 hours to complete. Can you please suggest what shall we do to make this Posting run faster?

Is there some tuning we need to do?

Regards,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Posting-Ledger-tp1241.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

Thanks.
We have contacted Oracle Support. There are 4 patches to be applied. We tested in test instance, Posting Ledger is running faster.
(Doc ID 1055606.1)

When I am applying patch 22850140, it is running for more than 1 hour(online patch). Do I need to wait?

I have checked the workers log I do not see any issue.

[ErmanArslansOracleBlog]

You didnt see any issue?
Maybe it gathers some stats, so it may be doing some serious db work.
I m on a vacation, so my connection is limited. If I had connection, I would check the patch folder and see its actions..I would check the sqls that it deliver..
Anyways, check from the database and also read the worker log files, use adctrl to see the current jobs of the workers and you will understand what they are doing..