Adadmin Multilingual Table Update Runs Long On Jtfnlins.Sql
(Doc ID 430573.1)
Last updated on APRIL 04, 2025
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |