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

From: Randolf Geist <mahrah_at_web.de>
Date: Thu, 6 Aug 2009 00:14:04 -0700 (PDT)
Message-ID: <689647c9-64a4-4d16-80af-da08aa6b1d29_at_c34g2000yqi.googlegroups.com>



On Aug 6, 2:07 am, Noons <wizofo..._at_gmail.com> wrote:
> Second insert was from a different session and it makes no difference
> whatsoever, at least in my system.
> Running 10.2.0.3 in AIX 5.3, with following patches applied:
> 5386204,6455161,5556081,5557962
>
> Like kevin said: I suspect this has more to do with undo/locking than
> ASSM itself.
> Like you said: we really need a scripted session to be able to
> reproduce the problem.

There is still a difference to the OP's description: The 10,000 rows inserts were supposed to be single-row inserts.

We also need to know the exact environment, e.g. the block size used in the tablespace, if it is a default or non-default block size in his database, indexes on the table being modified, block size of tablespace where the indexes are stored etc... There were some oddities in the past with ASSM and larger block sizes like 16KB, in particular with index maintenance, rows growing due to updates etc.

So we need not only a test case in form of a script for the DML performed, but also at least the exact description of the environment, or even better, the test case covers these details as well (tablespace creation etc.).

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 Thu Aug 06 2009 - 02:14:04 CDT

Original text of this message