Hi,
I am experiencing issue opening the table record (sys_db_object.do) when I try to open transaction is getting stuck in SQL/DB or probably GetIndexes function. I investigated and saw the logs, it took 7 minutes to getIndexes.
yokohama-12-18-2024__patch7-hotfix2-09-18-2025.
jdbc:oracle
Time: 0:00:00.263 id: SRNDB2[glide.10] for: SELECT I.INDEX_NAME, I.UNIQUENESS, C.COLUMN_POSITION, C.COLUMN_EXPRESSION FROM USER_INDEXES I, USER_IND_EXPRESSIONS C WHERE I.TABLE_NAME = C.TABLE_NAME AND I.INDEX_NAME = C.INDEX_NAME AND I.TABLE_NAME = "TASK"
Time: 0:00:07.428 id: SRNDB2[glide.10] for: SELECT I.INDEX_NAME, I.UNIQUENESS, C.COLUMN_POSITION, C.COLUMN_NAME FROM USER_INDEXES I, USER_IND_COLUMNS C WHERE I.TABLE_NAME = C.TABLE_NAME AND I.INDEX_NAME = C.INDEX_NAME AND C.COLUMN_NAME NOT LIKE 'SYS_NC%' AND I.TABLE_NAME = "TASK"
[0:07:09.533] DBIOracle#getIndexes(task);
Any thoughts are appreciated.
Thanks & Regards,
Mairaj
