On 1/9/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
Thanks everyone for your help. The only solution we could find, along with Oracle Support, was to bounce the instance and luckily it came back up with no problems. We don't have any solid root cause yet, but just a few possibly related factors to keep in mind: o We just upgraded to 9.2.0.8 a couple months ago (never had this problem on 9.2.0.4)
This is not new. I've encountered this as far back as 7.0.x. No root cause is ever found as we have never been able to reproduce this. Normally it only happens very infrequently. The solution has always been: 1) kill -9 PID 2) kill the session 3) if that doesn't work, shutdown abort and restart. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist