Re: import...dead or alive?

From: Diego Cutrone <diegocutrone_at_yahoo.com.ar>
Date: Wed, 30 Apr 2003 11:12:08 -0800
Message-ID: <F001.0058CF44.20030430111208@fatcity.com>

Saira,

I think you can also check what the import session is doing..

just find out its sid select from v$session_wait. Or just take a dump with oradebug or with 10046 event.

Or identify the corresponding transaction and select from v$transaction to check if USED_UBLKS is increasing...

HTH
Greeting
Diego Cutrone

-----Original Message-----
Saira,

  ps -ef | grep imp

It should tell if imp is still running.

If you have commit = Y, you can do a count on the table(s) being imported and see if the numbers are climbing. This can be misleading as indexes and other objects could be importing after the rows are all in the table.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

-----Original Message-----

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

---

Internet GRATIS es Yahoo! Conexión
4004-1010 desde Buenos Aires. Usuario: yahoo; contraseña: yahoo Más ciudades: http://ar.online.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: =?iso-8859-1?q?Diego=20Cutrone?=   INET: diegocutrone_at_yahoo.com.ar

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). Received on Wed Apr 30 2003 - 14:12:08 CDT