Re: Record Locking

Richard D. Beynon, Jr. wrote:
>
> I need some edification on how Oracle handles record locking.
>
> Can you get a read-lock if a write-lock exists on a record and vice-versa.
> - can a write lock be obtained after a read lock has been set?
> - If so, will the read view be refreshed?
> - can dirty reads be done for queries & reports while a write lock is set?
>
> Thanks for the help.
> --
> BTW, please respond via email as well as this newsgroup, since I don't get
> a change to check the newsgroups too often. Thanks.
>
> Rich Beynon
> The Stratus Group, Inc.
> E-Mail: rbeynon_at_stratusgroup.com
> Web: http://www.stratusgroup.com
> Voice: 215.750.6167
> "Bringing Technology to New Heights"

Read & Write never conflict and oracle never uses read locks. Oracle maintains read consistency views using rollback segments

-- 
    AMARENDRA B NETTEM
    Certified Oracle DBA
    WHITTMAN-HART INC., CHICAGO
    Homepage : http://www.iit.edu/~nettama
    E-mail : anettem_at_whittman-hart.com
             nettama_at_charlie.cns.iit.edu