Re: import...dead or alive?

Saira,

Just try this script to check whether rows are being inserted in imported table or not...

SELECT SUBSTR(SQL_TEXT,13,INSTR(SQL_TEXT,'(') - 14 ) TABLE_NAME, ROWS_PROCESSED ROWS_PROCESSED,
ROUND((SYSDATE - TO_DATE(FIRST_LOAD_TIME,'yyyy-mm-dd hh24:mi:ss') ) * 24 * 60 ,1) MINUTES,
TRUNC(ROWS_PROCESSED / NVL(((SYSDATE - TO_DATE(FIRST_LOAD_TIME,'yyyy-mm-dd hh24:mi:ss') )* 24 * 60),1) ) ROWS_PER_MIN FROM V$SQLAREA
WHERE SQL_TEXT LIKE 'INSERT INTO %'
AND COMMAND_TYPE = 2 AND OPEN_VERSIONS > 0 /

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wed, 30 Apr 2003 06:06:33 -0800

How can I find out if an import is dead or alive? I have an import of 1.6M+ rows that's been running for over 45 minutes.

Oracle 8.1.7.0.0
AIX 4.3.3 What can I check?

Thanks,
Saira

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani
   INET: saira_somani_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: M Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).