'latch free'

From: oradba guess <oradba_guess_at_hotmail.com>
Date: Fri, 03 Nov 2000 18:48:46 PST
Message-Id: <10669.121140@fatcity.com>

Hi,

        I am running a simple update on a table and it's just running forever. When I run on a small set of data, it runs fine. But when I run it on a large set of data, it simply hangs.

Query from the v$ tables are as follows:

SQL>select event from v$session_wait where sid=13;

EVENT

---

latch free

SQL> select * from v$session_event where sid=13;

     SID EVENT

---------- ----------------------------------------------------------------

TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT ----------- -------------- ----------- ------------ ----------

        13 SQL*Net break/reset to client
         19              0           0            0          0

Two things are confusing, if the query is running, why I am seeing " SQL*Net break/reset to client" and what exactly causing it to wait for latch free. There is nothin else running on the server except this update.

Any help will be appreciated.

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Fri Nov 03 2000 - 20:48:46 CST