Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Commit hangs.

MorvenAug 14 2012 — edited Aug 15 2012
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2012
Added on Aug 14 2012
18 comments
2,619 views