RE: MR/RT in V$Lock

From: Eric Fang <eric_fang_at_yahoo.com>
Date: Fri, 9 Jun 2000 10:32:00 -0700 (PDT)
Message-Id: <10523.108442@fatcity.com>

Thanks, Steve.

• Steve Adams <steve.adams_at_ixora.com.au> wrote:
  > Hi Eric,
  >
  > The MR locks are held by DBWn - one per datafile;
  > and the RT lock is held by LGWR. This is normal -
  > nothing to worry about.
  >
  > Regards,
  > Steve Adams
  > http://www.ixora.com.au/
  > http://www.oreilly.com/catalog/orinternals/
  > http://www.christianity.net.au/
  >
  >
  > -----Original Message-----
  > From: Eric Fang [SMTP:eric_fang_at_yahoo.com]
  > Sent: Friday, June 09, 2000 12:55 PM
  > To: Multiple recipients of list ORACLE-L
  > Subject: MR/RT in V$Lock
  >
  > I queried v$lock in the database. There are 17 rows
  > with 'Media Recovery'(MR), one with 'Redo
  > Thread'(RT).
  >
  > Does anyone what this means? Seems like they are all
  > related to redo logs, right?
  > Thanks.
  >
  > Eric Fang
  >
  > __________________________________________________
  > Do You Yahoo!?
  > Yahoo! Photos -- now, 100 FREE prints!
  > http://photos.yahoo.com
  > --
  > Author: Eric Fang
  > INET: eric_fang_at_yahoo.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  > --
  > Author: Steve Adams
  > INET: steve.adams_at_ixora.com.au
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!? Received on Fri Jun 09 2000 - 12:32:00 CDT