Re: Do you use ASSM (Automatic Segment Space Management)?
Date: Wed, 5 Aug 2009 01:14:54 -0700 (PDT)
Message-ID: <465abce5-4332-4256-a45f-d5228e225d28_at_v20g2000yqm.googlegroups.com>
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.
Regards,
Randolf
Oracle related stuff blog:
http://oracle-randolf.blogspot.com/
SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/
Received on Wed Aug 05 2009 - 03:14:54 CDT