Path: g2news2.google.com!postnews.google.com!v2g2000vbb.googlegroups.com!not-for-mail
From: John Hurley <johnbhur...@sbcglobal.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: ASSM bug: slow INSERT after uncomitted DELETE
Date: Sat, 8 Aug 2009 10:38:29 -0700 (PDT)
Organization: http://groups.google.com
Lines: 19
Message-ID: <b369d547-470c-41e2-b571-7bf0a2ff0392@v2g2000vbb.googlegroups.com>
References: <c26d8840-cb87-4390-9249-2b6293ca66f9@u16g2000pru.googlegroups.com> 
	<27de14dd-1d33-461a-ab24-245d026f6abe@v2g2000vbb.googlegroups.com> 
	<fN2dnQZfzJbZOuDXnZ2dnUVZ8h2dnZ2d@bt.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 1249753110 27611 127.0.0.1 (8 Aug 2009 17:38:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 8 Aug 2009 17:38:30 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v2g2000vbb.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)

On Aug 8, 12:26=A0pm, "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk>
wrote:

snip

> Given Charles comments about his timing on 11.1.0.7,
> how did you do the 1,000 single row inserts ? =A0Was it
> 1,000 separate statements, or a pl/sql loop with 1,000
> inserts and commits inside the loop /
>
> If the latter (or some Toad equivalent of the latter) that would
> explain why you don't see the problem.

Ooops ... also known as John screwed up the test case.