Re: read only tablespace

[Tanel Poder]

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