Re: Single record insert intermittently slow
Date: Fri, 28 Oct 2011 00:54:01 +0800
I guess you have done a 10046 trace, Which datafile/block/segment it's reading when the insert slow down?
You can get the rfile# and block# form p1/p2 of db file sequential read and find out the segment
select owner, segment_name, partition_name, tablespace_name, extent_id
where file_id = rfile#
and block# between block_id and block_id + blocks - 1;
http://www.freelists.org/webpage/oracle-l Received on Thu Oct 27 2011 - 11:54:01 CDT