Sudden Performance Problem - HELP

We have a pretty simpel DB setup. One schema that holds a table titles over 3,000,000 records and a table temp_titles. Once a month a new CD arrives that we load into temp_titles usually about 150,000 records. We have a load script that moves it from temp_titles to titles. Very simple script opens a cursor and shoots it across, no error messages or output.

This load takes 1-2 hours every month and this month has had to be killed after running for 36 straight hours. It never completes and we have no clue what to do or look at from here. Can someone please suggest something? I've heard I should analyse tables but what command should I use. I've also been told to export the table, drop it and import it. Is this a good idea?

BTW nothing has changed as far as Oracle parameters or server configuration during this month.

Thanks for ANY help.

Liz

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 08:39:53 CDT