Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Db2, Oracle, SQL Server
Noons <wizofoz2k_at_yahoo.com.au> wrote:
> Mark A apparently said,on my timestamp of 7/02/2005 2:12 AM:
>
> >
> > No I didn't say that. Transaction rollback does work with DB2 circular
> > logs.
>
> until it runs around the end of the log, eh?
>
> > You can allocate up to 2GB of memory for the DB2 locklist.
>
> and when that is all used up, the whole thing grinds to a halt.
> As I said: that is sooooooo scalable...
And when your 2 ITL slots in any given block are used up in Oracle.... And when your undo segments are filled up in Oracle....
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Mon Feb 07 2005 - 16:08:10 CST