Re: db file sequential read waits on INSERT into non-indexed partitioned table

From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
To: free <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 26 Sep 2011 14:43:20 -0700 (PDT)

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

» db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams
» Re: db file sequential read waits on INSERT into non-indexed partitioned table - Saibabu Devabhaktuni
» Re: db file sequential read waits on INSERT into non-indexed partitioned table- Gaja Krishna Vaidyanatha
» Re: db file sequential read waits on INSERT into non-indexed partitioned table- Greg Rahn
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams
» Re: db file sequential read waits on INSERT into non-indexed partitioned table- Greg Rahn
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams
» Re: db file sequential read waits on INSERT into non-indexed partitioned table- Gaja Krishna Vaidyanatha
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams
» Re: db file sequential read waits on INSERT into non-indexed partitioned table- jonathan
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- jonathan
» RE: db file sequential read waits on INSERT into non-indexed partitioned table- Wayne Adams