Re: How can one set the tracefile identifier for someone else's session??

I'd be asking the why and what version question at this point - it's entirely possible that a combination of DBMS_MONITOR and trcsess in 10g will help you.

That all said using oradebug to attach to the process gives you the ability to determine (but not set I think) the current tracefile name.

On 5/15/07, Andrew Zitelli <azitelli_at_gmail.com> wrote:
>
> Is there an easy way to set a tracefile identifier when tracing someone
> else's session? To trace my own session I simply use something like:
> alter session set tracefile_identifier='ANDY';
>
> The package DBMS_SYSTEM provides procedures SET_BOOL_PARAM_IN_SESSION and
> SET_INT_PARAM_IN_SESSION but nothing like SET_VARCHAR_PARAM_IN_SESSION. I
> have looked a bit on the web but have not found an answer for this. Is it
> possible?
>
> Thanks and kind regards,
>
> Andy Zitelli
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l