Re: long waiting for response

From: Willy Klotz <willyk_at_kbigate.stgt.sub.org>
Date: Sun, 24 Apr 94 23:32:02 GMT
Message-ID: <767230322snx_at_kbigate.stgt.sub.org>


okk_at_rz.uni-jena.de writes in article <2p40v3$nf2_at_hpux.rz.uni-jena.de>:
>
> Working under Oracle Rev. 7.0.13 I've got some trouble on executing simple
> statements. Example: creating a table sometimes works fine, sometimes is
> lagging (?) and won't stop.
>
> A closer look with 'monitor sessions' shows, that this session with the
> SELECT-, DROP- or any statement can't finish.
>
> What the reason could be?
>
> I tried with increasing 'processes', tried to change the profile - no
> effects. If one of this sessions is hanging, any selection operation
> fails!
>
> Now follows the result of 'monitor session' ...
>
> Session Serial Process Lock
> ID Number ID Status Username Waited Current Statement
> ---------------------------------------------------------------------------
> 6 1 9 ACTIVE SYS DROP TABLE
> 9 1 10 ACTIVE SYS SELECT
> 10 1 11 ACTIVE SYS SELECT
>
> ... still the same after one our :-( !
>
> Could you help?
>
> Marcel Khounlivong
> Student of Friedrich-Schiller-University Jena
>
Sounds like there is a problem with your configuration.... try using 'monitor latches', and look for 'enqueue resources' and 'dc_columns' in your init.ora.

Willy Klotz


Willys Mail     FidoNet   2:2474/117  2:2474/118     Mail Only System
                CIS: 100020,3517       USR Courier HST dual standard
                willyk_at_kbigate.stgt.sub.org
                ->   No Request from 06.00 to 08.00 <-
======================================================================
Received on Mon Apr 25 1994 - 01:32:02 CEST

Original text of this message