not a support question
Hi,
One of my production database shutdown process hangs every planned shutdown. (Both shutdown immediate and abort options).
Database version & OS : 10.2.0.4 on SuSe Linux 10 SP2, All the latest patches, cpus installed.
Some of the active database server process are preventing the database from shutdown. I tried to kill the process from OS root user also. But the process are not closing. When I check ps command the process are in 'D' state (uninterruptable sleep). For the particular pid, strace command also stuck. As I verified in v$session before shutdown immediate there is no active sessions or jobs in database. But above mentioned "D" state pid's are exist in v$process.
Please suggest me, how to find the history of the process.? like when it is hanged/which session id/which sql statement caused that..?
Thank you all,
Pratheep
