Re: Db2, Oracle, SQL Server

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Thu, 10 Feb 2005 08:41:05 +0100
Message-ID: <cuf6ed$563$2$8302bc10@news.demon.co.uk>

Morning Daniel,

> "When your 2 ITL slots ... are used"? What nonsense. We spend about two
> or three days scratching our heads and contemplating moving to DB2 and
> then some wiseguy says "increase the value of maxtrans" and then we all
> go back to surfing the web.

No we don't, because Oracle dynamically creates new ITL slots in the free space of the block - assuming that there is enough free space of course.

And you remember that increasing MAXTRANS only has effect on new blocks allocated for this table and not for existing one don't you ? :o)

Cheers,
Norm. Received on Thu Feb 10 2005 - 01:41:05 CST