Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Locking Up
Daniel Morgan wrote:
> Oracle 9.2.0.1.0 on a single CPU 1.7GHz Pentium IV
>
> One user doing SELECTS from various tables none with more than 10K rows
> and here's what I get:
>
> SQL> select event, seconds_in_wait
> 2 from v_$session_wait;
>
> EVENT SECONDS_IN_WAIT
> ------------------------------------------------------ ---------------
> null event 0
> pmon timer 3
> rdbms ipc message 0
> rdbms ipc message 0
> rdbms ipc message 154
> rdbms ipc message 3
> rdbms ipc message 3
> smon timer 208
> library cache pin 0
> library cache lock 3
> SQL*Net message from client 306
> SQL*Net message from client 926
> SQL*Net message from client 256
>
> The lock up and these waits are outrageous. Any ideas will be appreciated.
>
> It is a student's machine and I would like to try to fix the problem by
> email or phone rather than driving to their house.
>
> Thanks.
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace the x with a u to send email)
>
Patch to 9.2.0.3.0 or better.
Check network netup - probably tcp configured where ipc
would be faster (or even faster: beq)
-- Regards, Frank van BortelReceived on Tue Apr 29 2003 - 15:33:59 CDT