Skip to Content

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


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


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers