Re: coordinate my OracleDB with a foreign OracleDB: time-problem

DA Morgan schrieb am 07.01.2006 in
<1136668717.850652_at_jetspin.drizzle.com>:

Thanks for your answer,

> Andreas Mosmann wrote:

>> 3. connect to OtherDB
>> 4. copy all data from a view in OtherDB into MyDB -> CopyTable
>> 5. disconnect from OtherDB
>>
>> For this OvernightProcess I wrote another D6- App.
>> The amount of records is about 500 000. At the moment only these steps
>> take about an hour. This seems to be very long for me and is fairly in
>> time. I know that you probably cant tell my where I lose my time, but I
>> hope you can tell me where and how to search!

> Open a session using SQL*Plus and do it manually.

> But before you do ...

> SQL> set timing on
> SQL> DELETE ...
> SQL> set timing off

> This will tell you whether the time is being spent doing the delete or > somewhere else.

Sorry, but you misunderstood. Not the delete is the problem. Now I exactly know that the bunch of insert- clauses takes this time. But normally there should not be any indexes on it. But if so, would there be a way to find out which of these takes what time? I assume there is a problem with do less or small files (redolog, undo ...), but how to find out?

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de