Re: What is more costly ?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 29 Aug 2005 07:57:23 GMT
Message-Id: <pan.2005.08.29.07.57.23.265891@sbcglobal.net>

On Sun, 28 Aug 2005 17:40:38 -0700, DA Morgan wrote:

>
> Correct. It is impossible for an uncommited insert in Oracle to block
> anything.

Not quite. It can cause "ORA-01555 Snapshot too old" which will break (block?) concurrently running query. This is, of course, a pathological case, but a possible one.

-- 
http://www.mgogala.com

Received on Mon Aug 29 2005 - 02:57:23 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Asynchronous Commit in Oracle Database 10g R2"
Previous message: Ach C via DBMonster.com: "Test Data generator for oracle?"
In reply to: DA Morgan: "Re: What is more costly ?"
Next in thread: Daniel Fink: "Re: What is more costly ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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