Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Locking Up

Oracle Locking Up

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 29 Apr 2003 11:47:46 -0700
Message-ID: <3EAEC8D1.95FCED50@exxesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US