Migration from SqlServer 2005 very slow... Number of Commits very big!
616901Feb 13 2008 — edited Feb 15 2008Halllo,
I migrate from SQL Server 2005 to Oracle 10g using SQL Developer 1.2.1 (latest Build). I have 2 tables, with 27 million rows and 29 million rows.
1% data move needs 4-5 Hours!...
- no indexes or constraints
- Options: 10 000 rows to commit after. Tries: 500 000 does not help also.
- tables have not LONG, BFILE, REF, ROWID,UROWID, or
TIMESTAMP columns (I have readed, for tables containing this types columns, rows are inserted individually, with commit for each row).
In "DETAILED ADDM REPORT FOR TASK XYZ" at Oracle server kann I read:
(translated from germany, sorry for bad english...):
Waits on event "log file sync" during the execution from COMMIT-and rolling forecastle processes have booked essential data bank time.
RECOMMENDATION 1: Application analysis, 97% benefit (467900 seconds)
ACTION: Check the application logic for a possible reduction of the number of COMMIT processes by enlargement of the transactions.
RATIONAL ONES: The application has explained 2596 transactions per minute by an average Redo size of 824 bytes per transaction.
It looks thus each row is committed, why?
Any insight to tune it to go faster.
Please help, I have many searched, but no solution found.
Thanks,
Julia
null