Hello,
I am using oracle 11g importing the oracle 9i dump
to monitor the import progress
SELECT SUBSTR(SQL_TEXT,INSTR(SQL_TEXT,'INTO "'),30) TABLE_NAME, ROWS_PROCESSED,
2 ROUND((SYSDATE-TO_DATE(FIRST_LOAD_TIME,'YYYY-MM-DD HH24:MI:SS'))*24*60,1) MINUTES,
3 TRUNC(ROWS_PROCESSED/((SYSDATE-TO_DATE(FIRST_LOAD_TIME,'YYYY-MM-DD HH24:MI:SS'))*24*60)) ROWS_PER_MINUTE
4 FROM SYS.V_$SQLAREA
5 WHERE SQL_TEXT LIKE 'INSERT %INTO "%'
6 AND COMMAND_TYPE = 2
7* AND OPEN_VERSIONS > 0
TABLE_NAME ROWS_PROCESSED MINUTES ROWS_PER_MINUTE
------------------------------ -------------- ---------- ---------------
INTO "DAKC" ("A3912", "A3912A 15531558 117.5 132145
This is abnormal behavior. almost 1 hour it shows the same status no increase in rows processed. How can I confirm any import are in progress. and only ROWS_PER_MINUTE AND MINUTES ARE changing... I don't find rows_processed remains for almost 1 hour.
What went wrong and how can I check the same
S