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

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Wed, 30 Apr 2003 09:41:57 -0800
Message-ID: <F001.0058CD8F.20030430094157@fatcity.com>

I've seen it "hang" when it is re-collecting stats at the end of the import, just another possible reason.

Tim Onions
Head of Oracle and Web Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider Tel: +44.1684.312364
http://www.speechmachines.com

-----Original Message-----
Sent: 30 April 2003 17:47
To: Multiple recipients of list ORACLE-L

I'd bet that you were creating indexes when it seemed to you that nothing was happening. either that, or recreating the foreign key constraints which could take a lot of time while it verified that they were all valid.

glad it worked out for you. look at the "feedback" option within Import. it can indicate for you when a number of records have been inserted. i've used it for large imports and it helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, April 30, 2003 11:43 AM To: ORACLE-L_at_fatcity.com
Cc: 'Mercadante, Thomas F'

It does, thank you. The import just seemed to stall but after another few minutes, it completed importing the entire schema.

I guess I need to change the import parameters to give me some indication of where it's at.

Thanks for your help,
Saira

-----Original Message-----
Sent: April 30, 2003 11:35 AM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'saira_somani_at_yahoo.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
---------------------------------------------------------------------

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