Re: sqlnet.ora settings

The package you are thinking of is dbms_system.set_sql_trace_in_session

MarkP28665 wrote:
>
> From: Ed Stevens <73640.77_at_CompuServe.COM> >>
> I need to trace a particular workstation, when I set TRACE_LEVEL_CLIENT to some
> "on" level this necessarily turns it on for everyone. <<
>
> I can not remember the package name, off the top of my head, but the rdbms
> comes with a package that includes a procedure that can turn trace on for an
> already running session. Under Unix you would be able to locate the package
> name by searching on the word 'trace' in the $ORACLE_HOME/rdbms/admin
> directory. I wrote a cover procedure that my developers can use in the middle
> of the night when some job that runs in 30 minutes is still running after two
> hours and there are no locks on the system. You may wish to write the cover
> routine even if you are the only person who would be using it. The other
> procedures in the package are Oracle internal use only, and it is easier to
> remember a name like 'set_trace' than that blasted sys package.
>
> If you can not find it, e-mail me and I will log view my cover packagte code to
> see what the real package name is.
>
> Mark Powell -- Oracle 7 Certified DBA
> - The only advice that counts is the advice that you follow so follow your own
> advice -
Received on Fri Feb 20 1998 - 00:00:00 CST