Re: delete 20 000 records in oracle from perl

2009-08-17 Thread Chas. Owens
On Mon, Aug 17, 2009 at 02:00, luke devon wrote: > 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 th

Re: delete 20 000 records in oracle from perl

2009-08-17 Thread luke devon
To: luke devon Cc: Perl Sent: Monday, August 17, 2009 14:39:12 Subject: Re: delete 20 000 records in oracle from perl 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 be

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
From: Raymond Wan To: luke devon Cc: Perl Sent: Monday, August 17, 2009 14:12:27 Subject: Re: delete 20 000 records in oracle from perl 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

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