Re: Oracle Locking Up

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 29 Apr 2003 22:47:09 -0700
Message-ID: <3EAF635C.BDD71CB9@exxesolutions.com>

Frank wrote:

> 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

Not on a network ... stand-alone machine being run directly from the keyboard.

But yes ... thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Apr 30 2003 - 00:47:09 CDT