Re: DB Slow, v$session_wait shoeing SQL*Net message from client

Simon, what is your CPU consumption? Are CPUs executing oracle processes (top) or sitting idle? If CPUs are executing oracle processes, you may have a problem with parsing. If they're sitting idle and doing nothing, your client program(s) may be to blame or you may have a network problem. Have

DB Slow, v$session_wait shoeing SQL*Net message from client

Hi Gurus- Peformence of my DB(8174, Tru64 Unix) has terribly slowed down! Checked Indexes, Stats, etc but all look fine to me. Only one strange thing: I have more than 100 sessions in the v$session wait with same EVENT,P1TEXT, P1,STATE (SQL*Net message from client ,driver id,1413697536,WAITING).