Re: FTS, db file sequential read on undo
Date: Mon, 13 Apr 2009 19:01:05 +0200
Sorry. First reply and didn't watch how the "reply to" was set so it missed the list.
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?
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.