| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Locking Up
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)Received on Tue Apr 29 2003 - 13:47:46 CDT
![]() |
![]() |