Re: read only tablespace

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 30 Jul 2003 16:44:23 -0800
Message-ID: <F001.005C7E8F.20030730164423@fatcity.com>

Ah, one I have the answer to, as I had a similar question a while back.

The alter tablespace read only is waiting for every query which started before the alter tablespace was issued to finish. Just in case one of them might write to that tablespace and therefore fail.

so while the database does not HAVE to be quiesced before you issue an alter tablespace read only, it helps to prevent waits

• Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
  > Hi!
  >
  > Alter tablespace read only performs checkpoint on datafiles belonging
  > to this tablespace. But 10 minutes on an idle system is indicating
  > some problems.
  >
  > Check this: select event, p1, p2, p3, state from v$session_wait where
  > sid = <sid of waiting session>;
  >
  > You should get some indication, on what your alter tablespace command
  > is waiting.
  >
  > Tanel.
  >
  > ----- Original Message -----
  > From: AK
  > To: Multiple recipients of list ORACLE-L
  > Sent: Wednesday, July 30, 2003 10:34 PM
  > Subject: read only tablespace
  >
  >
  > why does it take long time to turn a tablespace read only . I
  > issued the command 10 mins back , its still not returned . There is
  > almost no activity in db .
  >
  > 8.1.7.4
  > hp-ux
  >
  > -ak
  

  ---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Wed Jul 30 2003 - 19:44:23 CDT