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 -> Re: Oracle Locking Up

Re: Oracle Locking Up

From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 29 Apr 2003 23:20:22 +0200
Message-ID: <3EAEEC96.2010301@netscape.net>


Frank wrote:

> 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)
> 

s/netup/setup
:wq

-- 
Regards, Frank van Bortel
Received on Tue Apr 29 2003 - 16:20:22 CDT

Original text of this message

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