Oracle Database Discussions

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.