Re: db file sequential read waits on INSERT into non-indexed partitioned table
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Mon, 26 Sep 2011 14:43:20 -0700 (PDT)
Message-ID: <1317073400.84610.YahooMailNeo_at_web65912.mail.ac4.yahoo.com>
Do you have flashback turned on and did you drop or truncate any objects in that tablespace? It is possible to see "db file sequential read" waitevent during insert into table data segment. Thanks,
Sai
http://sai-oracle.blogspot.com
Date: Mon, 26 Sep 2011 14:43:20 -0700 (PDT)
Message-ID: <1317073400.84610.YahooMailNeo_at_web65912.mail.ac4.yahoo.com>
Do you have flashback turned on and did you drop or truncate any objects in that tablespace? It is possible to see "db file sequential read" waitevent during insert into table data segment. Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 26 2011 - 16:43:20 CDT