Oracle always uses row level locks and never escalates locks (as long as you
are not using parallel server). Selects only cause row level locks if you
use the "for update" clause.
Regards
David
szidane_at_my-dejanews.com wrote in message
<6sp2ue$2fs$1_at_nnrp1.dejanews.com>...
>I'm using oracle 8.0.5. Is there any way of finding what kind of locking
>system i'm using (row level or table-level). what is the default?? I have
not
>set any parameters relating to this in the initSID.ora
>
>thanks
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 04 1998 - 15:26:32 CDT
