Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2006
    Posts
    10

    Unanswered: update takes long time

    hi all,
    oracel 8.1.7.4 aix
    update statement is taking 3 minutes to update could you provide me steps to optimize this statement
    update msg set assigntome= 774, status = 'In Progress', updat=sysdate where assigntome is null
    and ticket= 'LP342765324' and companyid = 664

    FREELIST 1
    NUM_ROWS 3165
    BLOCKS 485
    EMPTY_BLOCKS 113
    AVG_SPACE 2965
    AVG_ROW_LEN 2007
    ANALYZE DATE 3-Nov-2006 1:02:07

    66 COLUMNS
    TICKET - primary key
    STATUS - NONUNIQUE

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    How does explain plan look like?

  3. #3
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    Something quite amiss here, if your stats are accurate - 3 minutes to update a table with 372 blocks seems awfully long.

    Is your sql really that simple?

  4. #4
    Join Date
    Jul 2005
    Location
    jakarta
    Posts
    21
    your statement might be locked while you are trying to perform update. maybe there was a previous statement that used the same table for update and hasnt been COMMIT yet.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    But previous statements don't suddenly get committed after 3 minutes (unless, of course, another session (as opposed to a statement) locked the table).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •