Re: Oracle Locking Up

Might be totally unrelated to what is happening to your student but we applied patch 8.1.7.4 to 8.1.7.3 a few weeks ago to one of our machines.

We had a couple of users/applications that had the exact same symptoms you are showing. the query would appear to run, and never return to sqlplus.

On our end it turned out those users had never upgraded clients they were still using 7.3.4 which worked fine for an 8.1.7.3 database but not 8.1.7.4 with certain queries.

Not sure if that applies to your student or not but is it possibly an older client issue?

Scott Gamble

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in news:3EAEC8D1.95FCED50_at_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 Wed Apr 30 2003 - 21:58:14 CDT