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 Session Trace.

Re: ORACLE Session Trace.

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 12 Jan 2005 02:45:01 -0800
Message-ID: <1105523202.256230.125510@z14g2000cwz.googlegroups.com>


yong321_at_yahoo.com wrote:
> Niall Litchfield wrote:
> > It may not be so perfect if Dexter is running on Windows. I have
just
> > checked (because it is a long time since I ran oradebug) and it
> appears
> > that the trace doesn't get created on windows until the relevant
> > session ends.
>
> I often do oradebug on Windows. There're two anomalies compared to
> UNIX/Linux. Always use setorapid (v$process.pid), because setospid
may
> not work. Always do something on the debugged session, or the
debugging
> session hangs. This "something" can be as trivial as "desc
sometable",
> but not "set pagesize 100" which is 100% client side (DESCRIBE
actually
> connects to the server.) Exiting the session is an overkill.

Thanks for the clarification. I suspect that by the time I'd switched I may have had an inactive session.
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Wed Jan 12 2005 - 04:45:01 CST

Original text of this message

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