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

From: Noons <>
Date: Tue, 04 Aug 2009 21:04:25 +1000
Message-ID: <h594q4$m34$>

ca111026 wrote,on my timestamp of 4/08/2009 5:43 PM:
> 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.

I'll test that for you tomorrow our time. Do you have an index on the table as well? How long does that same test take without ASSM? Received on Tue Aug 04 2009 - 06:04:25 CDT

Original text of this message