RE: Import speed falls off at 2million rows
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "david.cheyne@xxxxxxxxx" <david.cheyne@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- 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.
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
