Oracle-L: RE: import...dead or alive?

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 30 Apr 2003 08:31:44 -0800
Message-ID: <F001.0058CBD9.20030430083144@fatcity.com>

Saira,

a simple way to check is to look at the size of the data files (using OEM). if you see the high water mark increasing, or the size of the rollback segments increasing, then you know that something is happening.

if you used the 'commit = y' parameter provided with the import utility, you could also do periodic 'select count(*) from table_name' to see if the record counts are growing.

hope this helps

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, April 30, 2003 10:07 AM To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------