RE: Import speed falls off at 2million rows
Date: Thu, 12 Mar 2009 10:09:16 -0700
Maybe it's not a problem with import, but a problem with your I/O performance? I suspect maybe you're writing to a RAID5 device and it's fast until you fill up the cache and then you hit the hideous reality of the RAID5 write penalty.
Take a look at "iostat -dx" or "sar -d" while the import is running to see if your disk service/wait times increase significantly when you see the import slow down.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Cheyne
Redo logs are now 1gb each and there are 5 groups. All data is on netapp.
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
http://www.freelists.org/webpage/oracle-l Received on Thu Mar 12 2009 - 12:09:16 CDT