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

From: Randolf Geist <mahrah_at_web.de>
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

Original text of this message