Re: long waiting for response

In article <2p40v3$nf2_at_hpux.rz.uni-jena.de>, okk_at_rz.uni-jena.de (Khamsonh Khounlivong) wrote:

> 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

Try to do a COMMIT; statement on the Terminals/Windows which are handling with the same table.
This should "free" the table.

I hope this helps,

Toni Received on Wed Apr 27 1994 - 00:54:27 CEST