Oracle TRC and TRM files are taking too much space at Oracle client computer.


  For some reason a lot of  TRC & TRM oracle files are being generated in a Oracle Client computer
when the user is performing some custom utility to extract Extract documents and metadata from a 2TB Oracle database.

  The path where those files are generated when the utility is running is C:\Users\xxxxx\Oracle\oradiag_hpateladmin\diag\clients\user_xxxxx\host_2046089961_xx\trace.

  I had to move those files to another location because of running out of space with the C:\ drive.

  How can i stop the generation of those files ?  --- for now i do not need them.

joe_echavarriaDatabase AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Check the client machines sqlnet.ora files to see if they have enabled tracing.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
joe_echavarriaDatabase AdministratorAuthor Commented:
What option in the sqlnet.ora files enables tracing ?
slightwv (䄆 Netminder) Commented:
There are several:

Most of them have TRACE somewhere in it.

When you say client:  Do you mean a client's database server or a client machine connecting to a database server?

If a database server, you might also check the alert log to see if something in there is telling you what is generating TRC files.
joe_echavarriaDatabase AdministratorAuthor Commented:
My SQLNET.ORA files  looks like  below now.  I made the changes to the parameter TRACE_LEVEL_CLIENT to value 0

# sqlnet.ora Network Configuration File: E:\app\oracle\product\11.2.0\client\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.



Open in new window

Is a client machine connecting to a database server.   It is actually the app server of the application.   The developer is running an utility recently provided by the vendor to extract documents and metadata.

I check the alert log of the database instance..., and there is nothing there about tracing files.

After having TRACE_LEVEL_CLIENT=0   in the sqlnet.ora file no trace files are generated now.

slightwv (䄆 Netminder) Commented:
Glad to help.  Unless you need something else, don't forget to close this out.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.