Putting multiple processes on rownum selection [message #316329] |
Thu, 24 April 2008 11:32  |
toshidas2000
Messages: 120 Registered: November 2005
|
Senior Member |
|
|
All
I have a package in which the cursor does rows selection for processing on rownum basis. Now I want to spam couple of processes in parallel, I cannot do as the cursor does selection on rownum. They can select same rows in parallel process.
I used FOR UPDATE SKIP LOCKED in cursor, but it did not work. I am 10g R2, Please help how can I put multiple processes.
Thanks
Toshi
|
|
|
|
Re: Putting multiple processes on rownum selection [message #316334 is a reply to message #316332] |
Thu, 24 April 2008 12:03   |
toshidas2000
Messages: 120 Registered: November 2005
|
Senior Member |
|
|
I clearly did not understand what you said. I have a primary key, but how it affects??
I do select * from table_a
where rownum<500
It processes this 500 rows. I want to make this process faster, but when I put another process. It does the same cursor??
select * from table_a
where rownum<500
Both might select the same set of row?? How do I use rowid. Please help...
|
|
|
|
|
|