Re: Do you use ASSM (Automatic Segment Space Management)?
Date: Wed, 5 Aug 2009 01:14:54 -0700 (PDT)
On Aug 5, 6:32 am, Noons <wizofo..._at_gmail.com> wrote:
> Something is definitely different in your system.
> Here are my results:
It's not clear from your output if you've followed the OP's description to perform the final insert from a different session, after the deletion of all rows from the table in the first session.
This might make a significant difference.
However I agree with previous contributors that providing a reproducible test case in form of a script including the setup/DDL to create/initialize the objects will be the most efficient approach, along with his results and the exact version/platform this was tested on.
Oracle related stuff blog: