Performance issue in dev server

Hi Team,

We have faced issue from application end at database level. One of the insert is taking long time and statement is not completed and its hanging.

DETAILS:

The issue is the same issue we faced after DEV DB migration Writing data directly to data files causes this problem I guess . This query below just keeps running and never completes.

On the OLD DEV/TEST Database servers this would hardly take 60-90 seconds. ( this is a table with ~1.5 million records )

INSERT /* +APPEND */ INTO FOTD_DEMANDS_JN SELECT * FROM FOTD_DEMANDS_JN@DOSPROD.FREESCALE.NET;

So I am not able to run/complete my routine – That is I cannot run any query after this . the session hangs up .