sqlnet.ora and ADR
Hi,
I have a quick question and hopefully easy to answer!
On our client machines with 11.2.0.4 Oracle 32bit and 64bit client installed we are getting GB's worth of trace files created in:
C:\Users\HZNSqlReporting\AppData\Local\Temp\oradiag_UNKNOWN\diag\clients\user_UNKNOWN\host_2481386155_80\alert
We have a TNSADMIN varioable set pointing to where the tnanames.ora file is located. We dont have an sqlnet,ora.
I am wondering if I wanted to disable ADR do I simply add an sqlnet.ora and set the following:
DIAG_ADR_ENABLED=OFF
My next question maybe a silly one but I have done a search on the client machine for the sqlnet.ora and could not find it so why is tracing enabled in the first place and at level 16 for that matter!