experts question.

From: richard <srichardchung_at_cs.com>
Date: 15 Oct 2002 05:52:30 -0700
Message-ID: <6a87bade.0210150452.6a4527b3@posting.google.com>

symptom:

no locks on v$lock.
select v$session showed most of the session are active, even the clients quit their client programs(some normal exit, some forced exit). Users session always in v$session unless we killed the Unix process. So,the # of session were piling up.
Users can login, and select on most tables are ok, some selected tables will hang their clients.
didn't check v$transaction.used_ublk for rollback.
CPU idle was 70% (12 CPUs). Only one or two Oracle processes are active in Top session.

We restarted the Oracle and the problems gone.

Can anyone shed some light on what happened in Oracle? So we can prevent it next time.

Thanks in advanced. Received on Tue Oct 15 2002 - 07:52:30 CDT