Re: Migrating from 6.5 SQL Server to Oracle 8.1

From: Tanel Poder <tanel_at_remove.this.peldik.com>
Date: Tue, 11 Feb 2003 20:13:25 +0100
Message-ID: <3e493d9f$1_1@news.estpak.ee>

Hi!

You are forgotting about MAXTRANS.
If inittrans is too low (and you have a little empty space in blocks (which you mostly do)) then Oracle can extend the number of transaction slots as needed, up to maxtrans or when you're out of free space in block.

Also, you can change the number of inittrans for a segment - in which case all new blocks allocated will have the new number of transaction slots. It won't help with concurrent updates to existing blocks that much, but inserts, for sure.

So, rebuilding the (big) table would be one of the last options for me..

Tanel. Received on Tue Feb 11 2003 - 13:13:25 CST