Hi all,
11g Enterprise Edition Release 11.2.0.2.0
I run into a odd problem, I have a table as below, it has a primary key on (LIST_ID, LANGUAGE_ID) , no other keys or indexes.
SQL> desc CACHED_APPLICATION_LIST
Name Type Nullable Default Comments
------------------ --------- -------- ------- --------
LIST_ID NUMBER(9)
LANGUAGE_ID NUMBER(9)
LAST_MODIFIED_DATE DATE Y
SQL> select count(*) from CACHED_APPLICATION_LIST;
COUNT(*)
----------
372
I try to update it with:
UPDATE cached_application_list cal
SET cal.last_modified_date = SYS_EXTRACT_UTC(SYSTIMESTAMP)
WHERE cal.list_id = 121;
It finished successfully, but sometimes when I try to
commit the transaction, it halts.
Since I don't have super privilege on this server, there's not much I can do, but I'm curious to know what would cause a
commit halt? I've never heard about this before. Any clue?
Thanks in advance.