Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE Session Trace.
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