Re: Single record insert intermittently slow

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Fri, 28 Oct 2011 00:54:01 +0800
Message-ID: <CAM_ddu_7+RYaeo=gVF-mT4hGj8X=ceJuY4UAWD_LrjiOBoF3xw_at_mail.gmail.com>

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 from dba_extents
where file_id = rfile#
and block# between block_id and block_id + blocks - 1;

--

Regards
Sidney Chen

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 27 2011 - 11:54:01 CDT