Re: ASSM bug: slow INSERT after uncomitted DELETE

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Sat, 8 Aug 2009 10:38:29 -0700 (PDT)
Message-ID: <b369d547-470c-41e2-b571-7bf0a2ff0392_at_v2g2000vbb.googlegroups.com>



On Aug 8, 12:26 pm, "Jonathan Lewis" <jonat..._at_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 ?  Was 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. Received on Sat Aug 08 2009 - 12:38:29 CDT

Original text of this message