Oracle TRC and TRM files are taking too much space at Oracle client computer.
Hi,
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\orad
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.
Thanks.
Example-of-trc-file.txt
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\orad
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.
Thanks.
Example-of-trc-file.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There are several:
http://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF006
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.
http://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF006
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.
ASKER
My SQLNET.ORA files looks like below now. I made the changes to the parameter TRACE_LEVEL_CLIENT to value 0
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.
Thanks.
# 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.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
[b]TRACE_LEVEL_CLIENT=0[/b]
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)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.
Thanks.
Glad to help. Unless you need something else, don't forget to close this out.
ASKER