Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Db2, Oracle, SQL Server

Re: Db2, Oracle, SQL Server

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Mon, 07 Feb 2005 08:59:09 +1100
Message-ID: <4206932D.6070100@yahoo.com.au>


Serge Rielau apparently said,on my timestamp of 7/02/2005 1:23 AM:

>
> That would be useless indeed. But no, it means that if the log bites its
> tail it will complain. That is if there is a long running transaction
> that prevents overwriting. Don't knwo of hands what happens. Obviosu
> reactiosn woudl be to either rollback the long running transaction to
> snip the tail or to disallow write transactions until the log is
> extended. By using a circular log you agree that up are ok without
> rollforward recovery, perfect for my laptop.

Shades of ORA-1555, eh?
The more they are "different", the more like they sound...

>
> In DB2 the most memory is consumed by
> the bufferpool. Locklist size is not an issue in reality.
> If it ain't a size issue it belongs in memory.

Yeah? So why the lock escalation in the first place?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Sun Feb 06 2005 - 15:59:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US