High db file sequential reads during imp?
- From: cam <kadmon@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 May 2008 08:22:11 +0100
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?
Regards,
cam
Other related posts:
