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

Re: Sqltrace for someone else's session?

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Sat, 25 Mar 2000 22:59:45 GMT
Message-ID: <BxbD4.10503$n03.450310@news20.bellglobal.com>


if you have oracle 7.3 and up use the :

DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(SID, SERIAL#, TRUE); regards,

Patrick Hamou
Oracle Certified DBA
patrickh_at_sympatico.ca

Werner Opper-Fritsch <Werner.Opper-Fritsch_at_de.bosch.com> wrote in message news:38DB2DD1.F9793C06_at_de.bosch.com...
> 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 Sat Mar 25 2000 - 16:59:45 CST

Original text of this message

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