Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Long Select freezes Instance

Long Select freezes Instance

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Tue, 24 Sep 2002 08:27:37 GMT
Message-ID: <20020924.8273770@mis.configured.host> 





Hello,



I'm running a Oracle 8i database on linux. Some select statements runs 
very long. That's ok, but if such statement runs, nobody else can work on 
the database. All sessions are freeze. What happens here? How can I 
change it?



Thanks 


Ralf
Received on Tue Sep 24 2002 - 03:27:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US