Re: FTS, db file sequential read on undo
Date: Mon, 13 Apr 2009 19:01:05 +0200
Message-ID: <8580d4110904131001k7d6c9eedu88d354756012f20a_at_mail.gmail.com>
Sorry. First reply and didn't watch how the "reply to" was set so it missed the list.
Vladimir,
That sounds very strange indeed. Is this a situation you see with any table or with just one? If you do a CTAS on dba_objects and export it, does it too suffer from this effect?
Have you just completed a large update to this table when you run this analyze/export or has the table not had any recent transactions when you run this? Do you suffer the same problem if you run your command twice in a row or is it just the first invocation that shows this effect?
Mathias
On Mon, Apr 13, 2009 at 5:36 PM, Vladimir Barac <vbarac_at_alghanim.com> wrote:
> When accessing table for analyze or to export table, we are seeing "db
> file sequential read" wait event. V$session_wait file# is 2, that is – UNDO
> tablespace. Because of this analyze or export take forever to complete.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 13 2009 - 12:01:05 CDT