Re: How to avoid waiting for locks during delete

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 13 Aug 2003 20:39:34 +0200
Message-ID: <e71ljv8t478p8g9sukr9jn5mjh437peft3@4ax.com>

On Wed, 13 Aug 2003 17:12:10 +0200, "André Hartmann" <andrehartmann_at_hotmail.com> wrote:

>I am not on a crusade. I was asking for clues on this issue. can you stop
>being unobjective and discuss more target driven ? If this thread pisses you
>off, why do you participate ?

OK, being unobjective. Who is unobjective? You are explaining you don't have *any* ( I repeat ANY control) over your datamodel, and you are sacrificing consistency for performance. And in a different reply you state you have transactions going on for 7 hours. So, inevitable conclusion: you have no control over your database, you live in a mess, and you are now trying to blame the locking behavior of Oracle instead of trying to resolve the mess. You should concentrate on getting the mess resolved instead of asking for 'clues' to continue symptomfighting. Because THAT is exactly what you are doing!!!

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 13 2003 - 13:39:34 CDT