Re: Do you use ASSM (Automatic Segment Space Management)?
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Tue, 4 Aug 2009 06:21:54 -0700 (PDT)
Message-ID: <3b03e495-98ea-4676-ac84-b8eef87e47d3_at_24g2000yqm.googlegroups.com>
On Aug 4, 3:43 am, ca111026 <ca111..._at_gmail.com> wrote:
Date: Tue, 4 Aug 2009 06:21:54 -0700 (PDT)
Message-ID: <3b03e495-98ea-4676-ac84-b8eef87e47d3_at_24g2000yqm.googlegroups.com>
On Aug 4, 3:43 am, ca111026 <ca111..._at_gmail.com> wrote:
snip
> Would you be able to do a simple test? Create average-size table in
> ASSM tablespace, let's say 1,000,000 rows with
> row size approx 100 bytes. Then insert additional 10,000 rows into the
> table using singe-row insert, record how long it takes.
> Then delete all rows from the table, don't commit.
> Then repeat insert of 10,000 rows from another session. Check how long
> it takes.
>
> In my tests second insert takes much, much longer - an hour instead of
> several seconds.
Write up this as a test case and supply sql and I will run it ... Received on Tue Aug 04 2009 - 08:21:54 CDT