Re: Sudden Performance Problem - HELP

Without knowing much details, here is my take:

Things to check:

1. Has the database been changed recently?
2. Is there any problem with this month's data?

Assuming "No" to both questions, then you might have "de-fragamention" is your database. This means the existing data is all over the place, the new data try to fill in these holes. You can get rid off this problem by "exp" all the data and "imp" them again. Also make sure you have enough extents available for new loads. Increase your rollback segment size for this new load, disable any constraints and load data then enable contraints. Are you using sqlloader or your own scripts to load data? I found sqlloader is fast.

Hope this helps.

Guang

In article <8plbn5$dqm$1_at_nnrp1.deja.com>,   elizabeth1000_at_my-deja.com wrote:
>
>
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 09:33:48 CDT