Help on Deadlock Detected. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Help on Deadlock Detected.

  1. #11
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by shans
    Since he is in 9.2.0.4 he should be in LMT, if so freelist doesn't make any sense.
    That's true only if segment space management is set to TRUE in that tablespace. But you can still have LMT with free blocks managed by oldfashioned freelist mechanism. Since we don't have any information regarding segment space management setting in original's post you can't say "freelist doesn't make any sense in LMT".
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #12
    Join Date
    Sep 2001
    Posts
    34
    Hi All,

    Thanks for all your replies, We are not using LMT's it is still dictionary managed tablespace. I am still not able to resolve the deadlock issue.

    Thanks,
    Prasad.

  3. #13
    Join Date
    Oct 2002
    Posts
    807
    I assume you have upped the initrans and freelists on the objects?

  4. #14
    Join Date
    Sep 2001
    Posts
    34
    Hi All,

    I see in the statistics for one of the process it has enqueue deadlocks equal to 1. Does this mean anything.

    Prasad.

Posting Permissions

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



Click Here to Expand Forum to Full Width