Re: delete 20 000 records in oracle from perl

2009-08-16 Thread Raymond Wan
Hi Luke, luke devon wrote: Thanks for the reply . Yes , when we going to delete those records , CPU is going high.So then its effecting to the performance. as i beginner in perl , how can i implement multi-threaded env ? Can you help me further ? Hm, well, I don't see any advantage of a

Re: delete 20 000 records in oracle from perl

2009-08-16 Thread luke devon
Hi Ray Thanks for the reply . Yes , when we going to delete those records , CPU is going high.So then its effecting to the performance. as i beginner in perl , how can i implement multi-threaded env ? Can you help me further ? Thanks & Regards Luke From: Ra

Re: delete 20 000 records in oracle from perl

2009-08-16 Thread Raymond Wan
Hi Luke, luke devon wrote: I wanted to delete some unwanted data in one of my oracle database.20 000 of records are there. This is actually on production . manually to delete a record , it takes 2 mins of time. So now i decided to write a perl script to do this function by learning on the

delete 20 000 records in oracle from perl

2009-08-16 Thread luke devon
Hi I wanted to delete some unwanted data in one of my oracle database.20 000 of records are there. This is actually on production . manually to delete a record , it takes 2 mins of time. So now i decided to write a perl script to do this function by learning on the web. Can somebody give me a