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