Path: news.cambrium.nl!textnews.cambrium.nl!feeder8.cambrium.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!r24g2000vbn.googlegroups.com!not-for-mail From: John Hurley Newsgroups: comp.databases.oracle.server Subject: Re: ASSM bug: slow INSERT after uncomitted DELETE Date: Sat, 8 Aug 2009 08:38:10 -0700 (PDT) Organization: http://groups.google.com Lines: 32 Message-ID: <9e338c1d-b399-44bb-957a-ee28eeaeb157@r24g2000vbn.googlegroups.com> References: <27de14dd-1d33-461a-ab24-245d026f6abe@v2g2000vbb.googlegroups.com> <14eac64f-9114-4801-a65a-2a250c8d069f@l34g2000vba.googlegroups.com> NNTP-Posting-Host: 75.10.157.214 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1249745890 777 127.0.0.1 (8 Aug 2009 15:38:10 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 8 Aug 2009 15:38:10 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: r24g2000vbn.googlegroups.com; posting-host=75.10.157.214; posting-account=_6ry2goAAAB8CmCVzS5u_8_rocyBncPn User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Aug 8, 11:04=A0am, Charles Hooper wrote: snip > > Thanks for testing on 11.1.0.7. It is nice to know that they finally > > fixed the bug. > > My test in your related thread indicates that the problem may still be > present in 11.1.0.7:http://groups.google.com/group/comp.databases.oracle.= server/browse_th... > > In my test, I saw results which were consistent with what you > experienced, which resulted from multiple waits on 'db file sequential > read' with sub 1ms access times for each insert in the second > session. =A0However, due to the number of 'db file sequential read' > waits, a fairly consistent 69,802 per row inserted, each insert > required roughly 20 seconds. > > John's post made be a bit curious, so I started performing a couple > tests. Charles I got a little lost trying to follow your reply ... sorry. Wonder if I either screwed something up ( I don't think so ... was careful to check tablespace was ASSM and that inserts were in different sessions ) or if there is something fixed in 11.1.0.7 in linux 64 bit that still has problems on other platforms and/or if the fact that my setup is using ASM is also throwing a wrinkle into things? Noons seemed to report that he did not see the same problem either but I think that was before the complete test case was posted.