Re: ORacle Locks

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Fri, 4 Sep 1998 17:24:28 -0700
Message-ID: <6sq038$bh7@dfw-ixnews6.ix.netcom.com>

the level of locking depends on the nature of your transaction. Query the v$lock and v$locked_object to get more information about what object being locked by what kind of lock. But do check the Oracle Server References manual for the explaination to decode the "type" of the lock.

WInnie

szidane_at_my-dejanews.com wrote in message <6sp3h9$3c2$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I'm using oracle 8.0.5. Is there any way of finding what type of locking
>system i'm using (row level or table level locks). what is the default??? I
>have not set any parameter wrt to locks in mu 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 - 19:24:28 CDT