RE: FTS, db file sequential read on undo
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "vbarac@xxxxxxxxxxxx" <vbarac@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 13 Apr 2009 11:50:35 -0400
Delayed block cleanout comes to mind.....
-Mark
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Vladimir Barac
Sent: Monday, April 13, 2009 11:36 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: FTS, db file sequential read on undo
Hello, listers
We are facing rather strange situation...
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.
Why would analyze or export access UNDO tablespace? There are definitely no
transactions at all on the system going on at the time of export/analyze.
Thanks for all insights,
Vladimir Barac
Database administrator | Alghanim Industries
P.O. Box 223, Safat 13003, Kuwait
Tel: +965 1881 111 / ext. 2960
[cid:image002.jpg@01C9BC2E.0E038900]
______________________________________________________________________
This e-mail message and any attachments to it are for the sole use of the
intended recipients and may contain confidential and privileged information.
This e-mail message and any attachments are the property of Yusuf A. Alghanim &
Sons w.l.l. or any of its subsidiaries or affiliates (?Alghanim Industries?).
Any unauthorized review, use, disclosure, or distribution of this e-mail
message or its attachments is prohibited. Any opinions expressed in this
message are those of the author and do not necessarily reflect the opinion of
Alghanim Industries. If you are not an intended recipient, please notify the
sender by reply e-mail and destroy all copies of the original message and any
attachments.
______________________________________________________________________
Other related posts:
