Re: High db file sequential reads during imp?
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 9 May 2008 12:09:17 +0300
Message-ID: <6e49b6d00805090209q7ae7c525g51e008f5b79ec9af@mail.gmail.com>
Date: Fri, 9 May 2008 12:09:17 +0300
Message-ID: <6e49b6d00805090209q7ae7c525g51e008f5b79ec9af@mail.gmail.com>
Any chance of having enabled unique index and imp checking whether the
new imported values are not already there?
Gints Plivna
http://www.gplivna.eu
2008/5/9, cam <kadmon_at_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 <skipped>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 09 2008 - 04:09:17 CDT