Re: Where to find information about LOCK_TYPE?

I understand that it is very satisfying to know where you can find exactly what you want in the Oracle library.
However - what you sent a link to is also a list that I found very fast and it is not what I am looking for. What I want is a in-depth explanation of the meaning for each of the codes.

Randi W.

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F3CDDB6.2FD1FF27_at_remove_spam.peasland.com...
> It took me about 7 seconds to come up with the following link:
>
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch396.ht m#1117007
>
> HTH,
> Brian
>
> "Randi Wølner" wrote:
> >
> > Hello,
> > I have run the script catblock.sql, and I can find out a few things when
> > executing a select * from dba_lock. But - there is also some information
> > there that I would like to know more about, but can not find. I have
spent
> > some time now searching in Oracle documentation (Tahiti), and found a
lot
> > about lock_types TM, TX, RS, RX, S, SRX and X.
> > I have been searching for information about MR - Media Recovery, RT -
Redo
> > Thread and TS - Temp Segment. I have a feeling that these lock types are
> > nothing to worry about, but I would like to know what they mean. There
are
> > also other possible values of lock_type that I could not find
information
> > about.
> > Can anyone give me a hint on where to look?
> >
> > Randi W.
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Mon Aug 18 2003 - 03:05:48 CDT