> Beside, I would like to see the result of strace(system call > tracer) for the hung session for more information like which > system call was being stuck with which parameters... > > ================================ > Dion Cho - Oracle Performance Storyteller Good point. Also helpful is the process call stack. The easiest way to get to see that is by running "pstack <shadow process id>". The top part of the stack may give us a clue. You can install this little utility now. On Red Hat 4, as root, "up2date pstack". Yong Huang -- //www.freelists.org/webpage/oracle-l