waiting for active calls to complete

[dragon99]

Hi, all
Recently, I performed a shutdown immediate, it hangs there forever, and I am sure no active transactions are going on. when I check the alert log file, the last lines is :
Tue May 15 15:30:47 2001
Restarting dead background process EMN0
EMN0 started with pid=49
Tue May 15 15:31:45 2001
Shutting down instance (immediate)
License high water mark = 125
Tue May 15 15:37:04 2001
SHUTDOWN: waiting for active calls to complete.

Since I do not want to wait, I use shutdown abort and restart the db.

What does it mean here by showing waiting for active calls to complete? Can anybody help? Thanks in advance.

Dragon

[sambavan]

The reason could be that when you issue the shutdown immediate, oracle would notify all its processes that a shutdown immediate had been issued. As a result, they all have to roll back their transactions. As a result it would wait there.

One of the other occasions that this scenario could occour is that when you have the oracle intelligent agent running and then the process waits until you close the agent.

You can check how much roll back would have to be performed during this process from doing a query on v$transaction view.


Sam