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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
