RE: Waiting for smon to disable tx recovery

Bill,

> database running on Solaris 7. The alert log shows an ALTER
> DATABASE CLOSE
> NORMAL and then Waiting for smon to disable tx recovery. The smon process
> has now used about 52 minutes of CPU time.Is there a way for me to
> determine what is going on? Earlier in the day I had killed a
> process that
> seemed to be running out of control and that process never
> cleaned up but I
> don't know what the interaction is.

It is likely that previously killed process created many temp objects (maybe even in non-temp tablespace?). In this case smon will spin as long as it takes to clean all of them up. DBA_EXTENTS should be helpful in identifying this situation, as well as sys.uet$ and sys.fet$ Received on Tue Dec 05 2000 - 08:13:30 CST