Deadlock issue in using 'APPEND' hint in multithreaded jobs running in parallel

This is a discussion on Deadlock issue in using 'APPEND' hint in multithreaded jobs running in parallel within the Oracle Database forums, part of the Database category; Hi Tom,We run many Pro*C jobs (multithreaded ones) in a batch. One of them runs on 16 threads, ...
 
Members Login.
 

Please register HERE to be part of our Community

Oracle Database » Current Topics
 

Popular Social Groups.
 
The active BRL users
cwp (web development)
Malaysia Member
Richest Members

Contest of the Day.
 
Contest # 8 (Longest Thread Contest)

Invite Your Friends...
 

Invite your contacts from social groups / email address book to Join BRL.
Information is transmitted over secure channel.
We don't store any information.


Sponsors.
 



BRL Webmaster Forum » Programming & Web Development » Database » Oracle Database » Deadlock issue in using 'APPEND' hint in multithreaded jobs running in parallel

Oracle Database Discussion related to Oracle database issues, queries, questions

Reply
  #1 (permalink)  
Old July 12th, 2007, 20:42 PM
Administrator

Join Date: Jun 2007
Posts: 3,709
BRL$: 42,903.55
Thanks: 0
Thanked 14 Times in 10 Posts
Rep Power: 409
Rss_Feeds is on a distinguished road
Default Deadlock issue in using 'APPEND' hint in multithreaded jobs running in parallel

Hi Tom,We run many Pro*C jobs (multithreaded ones) in a batch. One of them runs on 16 threads, which run at the same time, and internally use the 'APPEND' hint while inserting into a single table. Recently it failed with 'ORA-00060: deadlock detect...


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
__________________
High Quality
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Powerful
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


Jobs In !!! - Post Jobs, Hire Employees, Create Blogs and Earn Money.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Tags
append, deadlock, hint, issue, jobs, multithreaded, parallel, running


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
Terms Of Usage

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106