High db file sequential reads during imp?

From: cam <kadmon_at_gmail.com>
Date: Fri, 9 May 2008 08:22:11 +0100
Message-ID: <2609b6ef0805090022j737664abq7d76c8185217ae2f@mail.gmail.com>

Hello all,

Relative newcomer to performance analysis. I was surprised, upon investigating a very slow import job, to find very high 'db file sequential read's. This activity was mostly associated with an index that was being updated while around 11 million rows were inserted to a normal heap table. I'm clearly missing something obvious here but why would imp be reading (and not writing?) so heavily from this index?


Received on Fri May 09 2008 - 02:22:11 CDT

Original text of this message