SqlPlus not responding in Oracle 10.2.0 on Linux Red Hat 4
We have Oracle 10.2.0 on Linux Red Hat 4.
It seemed to work fine since last friday when the database became hung.
We can't enter into the DB because sqlplus is not responding.
Top command shows this: (there is no idle CPU!!!)
[root]# top
top - 08:22:09 up 202 days, 17:36, 2 users, load average: 34.49, 34.42, 34.37
Tasks: 183 total, 37 running, 145 sleeping, 0 stopped, 1 zombie
Cpu(s): 47.6% us, 52.4% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 8309200k total, 6537988k used, 1771212k free, 241200k buffers
Swap: 9213268k total, 64212k used, 9149056k free, 3932772k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25522 oracle 25 0 604m 106m 106m R 32 1.3 1622:38 oracle