Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am doing migration to move data from Ms SQL Server 2000 to Oracle 11g on HP Server machine. I don't know why it is very slow when I load data from file xxx.dat into table in oracle 11g.

Do anyone help me to solve my problem?

Thank, Ung Sopolin

share|improve this question
add comment

3 Answers 3

Yes it is slow. You might want to use an SQL Migration tool one way or the other.

share|improve this answer
    
I am suing SQL Developer Tool. When I migrate oracle 11g on window, its speed 1000 records. But when I migrate oracle 11g on linux, its speed only 100 records. –  Sopolin Jul 31 '09 at 6:54
1  
This wasn't clear in your question. Also you'll have to be specific about what's different in the two machines besides the OS if you want anyone to guess at the 10 fold difference. –  dlamblin Jul 31 '09 at 16:22
    
I mean that I do migration on different machine but the speed isn't the same. I don't know why in the linux it is so slow. –  Sopolin Aug 6 '09 at 1:22
add comment

You might want to consider using the NOLOGGING clause when inserting bulk data from files.

ALTER TABLE[SPACE] name NOLOGGING;

This would turn off logging of DML and DDL actions on the specified table or tablespace. What this basically means is your inserts won't write to the redo logs, which should speed up the whole process. Don't forget to later turn redo logging back on using

ALTER TABLE[SPACE] name LOGGING;
share|improve this answer
    
I type the command as you gave me, but moving the record still slow. Could you other solution for me? Thank for advice me. –  Sopolin Aug 6 '09 at 1:25
add comment

If the two Oracle machines are similar in hardware specification I'd suggest looking at the built in Enterprise Manager website site (DBCONSOLE) that should be part of each 11g instance.

There should be a "Performance" tab that will give you a good idea of what is causing the performance difference between the two databases.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.