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.

Other related posts: