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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle materialized view strange problem.

Re: Oracle materialized view strange problem.

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 25 Apr 2006 14:55:12 GMT
Message-ID: <1145976911.483515@proxy.dienste.wien.at> 




Jack <amitkr.3_at_gmail.com> wrote:




> diffrent session....(lots of procedures fired after one another through

> unix shell script).... so session changes




Have you had a look at the explain plans? If you start the queries
with sqlplus, you could SET AUTOTRACE ON before you execute the query.



Also, when the query takes a long time, are there any locks on the database?



Yours,


Laurenz Albe
Received on Tue Apr 25 2006 - 09:55:12 CDT












Original text of this message













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