Re: Why does my process hang?

From: Francis Small <fthes_at_sr.hp.com>
Date: 11 Feb 1999 22:11:06 GMT
Message-ID: <79vkhq$jg1@canyon.sr.hp.com>

Vinay Joshi (vjoshi_at_pinnacle.co.uk) wrote:
: I believe you are missing an index on one of the tables.
: If you donot have an index, oracle does a full table lock.

An index does indeed solve the problem for the example I gave, but unfortunately not in my application even after I added indices :-(. Back to re-boiling my situation for the essentials...

Francis

--
| . . . . 5 . . . . 10. . . . 15. . . . 20. . . . 25. . . . 30. . . . 35. . .

Padres                                         Francis Small - M/S M1RA     
Giants                                           Test Engineering
Bums                                               Microwave Instruments Div.
Rockies                                              telnet 794-3305
Diamondbacks                                           fthes_at_sr.hp.com
******************** Only 53 days left until Opening Day ********************

Received on Thu Feb 11 1999 - 16:11:06 CST