Re: ASSM bug: slow INSERT after uncomitted DELETE

"John Hurley" <johnbhurley_at_sbcglobal.net> wrote in message news:27de14dd-1d33-461a-ab24-245d026f6abe_at_v2g2000vbb.googlegroups.com... On Aug 7, 6:35 am, ca111026 <ca111..._at_gmail.com> wrote:

>
>Thanks for the complete writeup.
>
>I tried your test case. My system is an 11.1.0.7 Enterprise Edition
>64 bit system on OEL 5.2 64 bit. It has 32 gig of RAM and a very nice
>IO subsystem. Using ASM for storage.
>
>My times to complete steps 4 and 6 ( yes from different sessions )
>were the same basically ... not different times as you reported. My
>testing was done using Toad going into the database thru network not
>locally on the database server using sqlplus. My times were more like
>3 secs than 1 ( as your first step 4 was ).
>
>I can repeat again eventually using sqlplus locally if you want to
>know if that changes anything.
>
>I do have one system back at 10.2.0.4 that I can eventually also test
>on.

John,

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.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html