Skip to Content
0
Former Member
Dec 05, 2006 at 01:38 AM

Oracle hangs sometimes during import

42 Views

Hello,

I'm doing a migration of a SAP R/3 4.6C system running Tru64 oracle 9.2.0.5 to Solaris Oracle 9.2,0.7 and during the third test import I noticed a strange behavior at ORACLE level.

The source system has 1,2Tb, after the import the DB size is 900Gb. Anyway the last 2 imports I've made it in less than 30hours (export/import), now during this test and the conditions are the same, also the oracle parameters the R3load processes start fine and with the right response time, 15 minutes after Oracle start behaving strange and CPU keeps in IDLE state. with this performance not even in 2 days this process will finish.

I'm running the Import with 10 processes.

Does anyone know what is happening to Oracle performance?

Thanks in advance

Fernando Figueiredo