Adadmin Multilingual Table Update Runs Long On Jtfnlins.Sql (Doc ID 430573.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Common Applications Calendar - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

In  11.5.9 codeline whilst running the adadmin function to Maintain Multilingual Tables:
the sql JTFNLINS.sql takes more than 8 hours to complete

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Run Maintain Multilingual tables in adadmin

the issue can be identified by taking a tkprof trace of running the sql, the output will be like below.

 

UPDATE JTF_NOTES_TL T SET ( NOTES, NOTES_DETAIL ) = (SELECT B.NOTES,
B.NOTES_DETAIL FROM JTF_NOTES_TL B
WHERE
B.JTF_NOTE_ID = T.JTF_NOTE_ID AND B.LANGUAGE = T.SOURCE_LANG) WHERE (
T.JTF_NOTE_ID, T.LANGUAGE ) IN (SELECT SUBT.JTF_NOTE_ID, SUBT.LANGUAGE FROM
JTF_NOTES_TL SUBB, JTF_NOTES_TL SUBT WHERE SUBB.JTF_NOTE_ID =
SUBT.JTF_NOTE_ID AND SUBB.LANGUAGE = SUBT.SOURCE_LANG AND (SUBB.NOTES <>
SUBT.NOTES OR (( DBMS_LOB.COMPARE(SUBB.NOTES_DETAIL, SUBT.NOTES_DETAIL,
DBMS_LOB.GETLENGTH(SUBB.NOTES_DETAIL),1,1)) <> 0) OR (SUBB.NOTES_DETAIL IS
NULL AND SUBT.NOTES_DETAIL IS NOT NULL) OR (SUBB.NOTES_DETAIL IS NOT NULL
AND SUBT.NOTES_DETAIL IS NULL) ))


call                  count            cpu           elapsed            disk            query            current               rows
-------             ------       --------       ----------      ----------     ----------      ----------      ----------
Parse                 1                0.03            0.52               9                    102             0                    0
Execute              6            1889.20        36441.42     9101466     64087015      1854                 0
Fetch                 0                0.00            0.00               0                    0                0                     0
-------            ------        --------       ----------       ----------     ----------      ----------     ----------
total                   7            1889.23         36441.95     9101475     64087117       1854                0

 



Changes

issue is noted when first adding languages in an 11.5.9 environment

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms