Here is what I did. I think the part about latch issues with constraint check is it. Next time I do a load, I'll disable the foreign key.
Here is what I did:
- insert select of about 7 million records(about 300 MB of data) to the parent table. Took about 2 hours.
- Did the exact same thing to the child table. So in this case it set up a 1-1 relationship. I haven't been able to get into the server since yesterday, but last I checked I was about 7 hours in and v$session_longops showed about 35% of the blocks read.
There was absolutely no additional use on the database or the server. I was the only one on it.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Thu Apr 22 2004 - 07:26:36 CDT