Re: Client connection SHARED don't use server SQLNET.ORA

On 2 Jul 2004 08:21:10 -0700, crapisi_at_tiscali.it (@lex) wrote:

>Hi !
>
>I need (maybe) a simple help..
>
>I test that when i use a client connection of type SHARED, i can't
>trace that from server (by TRACE sqlnet.ora parameter); instead i can
>trace it when i use DEDICATED connection. What's this ?
>
>Thanks for attention.
>Bye
>Alex
>
>System description:
>XP Client with Oracle 9.0.1.0 -> Aix Server with Oracle 9.2.0.5

This is by design, a result of using MTS. There is no guarantee your requests are being adressed by a single MTS server. If you run the ordinary sql-trace you will see your user session ends up in various MTS server trace files.

--
Sybrand Bakker, Senior Oracle DBA