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)
>
Daniel, what is the problem? I don't think SQL*Net waits are
the problem, it usually happens when you have set pause on in sqlplus
session. The high value of smon timer looks like related to bug 2717586,
which says that it fixed in 9.2. Never mind, it might be one of the bugs
popping up in different versions. How long session was active? And the
main question is: does user really have big response times?
Received on Tue Apr 29 2003 - 23:39:30 CDT
