Re: Do you use ASSM (Automatic Segment Space Management)?

From: John Hurley <>
Date: Tue, 4 Aug 2009 06:21:54 -0700 (PDT)
Message-ID: <>

On Aug 4, 3:43 am, ca111026 <> wrote:


> 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

Original text of this message