Hi Arup
Your paper brings me to a possible solution of a problem we encountered
while doing mass deletes (had to be delete, not truncate). Do you think =
the
following might be possible:
a) Table created with blocks of size 8k, inittrans 10, maxtrans 255.
b) Table only contains one column, number(28) (it holds key values).
c) mass delete on table.
d) delete hangs indefinitely.
Is it possible, since so many rows fit into one block, and each row my
transaction wants to delete results in an itl entry (is that the case =
anyway
=3D> one entry per row? or is it one entry per transaction per block?), =
that
there aren't enough slots left in a block and the delete hangs with an
enqueue wait?
Any input appreciated,
Stefan
-----Urspr=FCngliche Nachricht-----
Von: Arup Nanda [mailto:orarup@(protected)]
Gesendet: Freitag, 13. Februar 2004 05:37
An: oracle-l@(protected)
Betreff: Re: How do commits release row level locks?
I wrote an article some time ago for DBAZine on this exact question. =
Pleas
check this out at http://www.dbazine.com/nanda3.html.
----- Original Message -----=20
From: "Ryan" <ryan.gaffuri@(protected)>
To: <oracle-l@(protected)>
Sent: Thursday, February 12, 2004 11:13 PM
Subject: How do commits release row level locks?
> Now Oracle does not track which rows are locked. How processes know =
when a
lock has been released? I can't find it in the docs. I'm assuming there =
is
something similiar to an SCN written to the block header of each row.
However, the SCN would not be sufficient, since it does not identify =
whether
the transaction is complete.
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
