Re: Do you use ASSM (Automatic Segment Space Management)?
From: ca111026 <ca111026_at_gmail.com>
Date: Tue, 4 Aug 2009 00:43:36 -0700 (PDT)
Message-ID: <6185984b-6119-4b58-8e43-8c019c3fefd2_at_2g2000prl.googlegroups.com>
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.
Date: Tue, 4 Aug 2009 00:43:36 -0700 (PDT)
Message-ID: <6185984b-6119-4b58-8e43-8c019c3fefd2_at_2g2000prl.googlegroups.com>
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. Received on Tue Aug 04 2009 - 02:43:36 CDT