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>


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-l
Received on Fri May 09 2008 - 04:09:17 CDT

Original text of this message