luke devon <luke_de...@yahoo.com> asked: > Since i have more binary data to be deleted in the requested query , i > have to use a external script/program to satisfy the deletion. So thats > why i wanted to know , how can we implement multi threading for the > situation.
You said that CPU load is high when deleting the records, and yet you want to do multiple delete queries at once? That doesn't sound like a good idea to me ;-) Also, if a delete query on a single records takes two minutes, then it might be worth your while to investigate the causes. Is there an index on the key you're using to select rows to delete? Have you had a pro look at the database configuration? I seem to recall that unlike "consumer" DBMS like MySQL, Oracle requires frequent tuning to optimize performance. HTH, Thomas
