Re: Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core

I thought about dropping and then recreating the indices but the creation takes 60-80 minutes depeding on what else the machine is doing. I believe it takes so long as we use functional indicies.

As you can probably tell, I am not an Oracle DBA. I will ask the DBA to look into partitioned views and segment management.

Many thanks.

Comment on Re: Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core

Replies are listed 'Best First'.
Re: Re: Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core by fx (Pilgrim) on Jan 02, 2004 at 15:34 UTC
It just goes to show that you should always think about the big picture. After I went back to the DBA and complained about the speed it was discovered that one of the foreign keys used for joining was not indexed. Adding this index speeded one of the cascaded deletes up from 3-5 seconds to "very quick". I now have reasonable speed from the SQL calls but my problem still lies in the fact that it can take hours to apply a "big" update which I have just been told is around 110,000 records. I am therefore still looking for some way to increase the performance of my code.	[reply]
Re^4: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core by elf_firein (Acolyte) on Jan 06, 2009 at 09:18 UTC
Hi fx, Have you become able to solve this problem? I am getting similar error after 10000 records. You can see my post also. With Regards, kaustuv	[reply]