Re: ASSM bug: slow INSERT after uncomitted DELETE
Date: Sat, 8 Aug 2009 17:26:46 +0100
"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 188.8.131.52 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
Given Charles comments about his timing on 184.108.40.206, 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.htmlReceived on Sat Aug 08 2009 - 11:26:46 CDT