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: Sqltrace for someone else's session?

Re: Sqltrace for someone else's session?

From: Werner Opper-Fritsch <Werner.Opper-Fritsch_at_de.bosch.com>
Date: 2000/03/24
Message-ID: <38DB2DD1.F9793C06@de.bosch.com>#1/1

Hello,

 I have nearly the same problem with a application. At one time a day there seems to be
 a lock in the database for about 10 minutes, than it is released and everything works fine again.
 If I'd set sql_trace to true, where would I see the results ?  Is there a special tracefile to look for.  It is quiet serious that this happens at nearly the same time for about 4 days a week, some days happens
 nothing and after that the same procedure happens at a different time.  Any ideas for getting closer to a solution are wellcome.

 Thanks in advance.

Regards
 Werner

>
Received on Fri Mar 24 2000 - 00:00:00 CST

Original text of this message

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