/scripts/ahub.form.attachments.js
0

Access on Table TOA03 really slow since Oracle 12c Upgrade (Tx: /n/AFI/DIC_MONITOR)

Dec 06, 2016 at 06:20 PM

91

avatar image

Hello,

currently I have a performance issue when using Tx "/n/AFI/DIC_MONITOR" (DirectINVOICEControl Monitor). I enter a document number -> Search -> Doubleclick on "Doc.Num." -> Start Release -> Chose a workflow sequence. Now, from here on it gets really slow.

Usually this took like 3-4 seconds. Now it takes about 60 seconds. Running a SQL trace we saw that Operation "Fetch" onto table "TOA03" takes very long.

Doing this in the QA system takes only the expected couple seconds.

Database is running on the same server, no application server, no helpful entry in work process trace,... no idea.

Any clues from your side? How can I find out what operation is taking so much time?

Regards and thanks in advance

Daniel

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content