Skip to Main Content
  • Questions

  • Larget number and large in size of trace file are getting generated from my oracle instance

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Subbarao.

Asked: February 17, 2022 - 5:01 am UTC

Last updated: March 14, 2022 - 3:50 am UTC

Version: 19c

Viewed 10K+ times! This question is

You Asked

Dear sir

I have noticed, a huge number of trace files are getting generated with large in size like 4000 files in a day with a minimum of zero size and a maximum of 1gb

I have the following values in my parameter file.

sql_trace=false
Trace_enabled=false
-- I have executed the following statements also;
alter session/system set events = ‘10046 trace name context off’;

But the issue is not resolved. Requesting your kind advice.

Regards
Subbarao Dasari

and Connor said...

Trace file can be *anything* (background processes, foreground processes, etc).

You need to have a look *inside* them to see what content they hold.

For example, here on my local laptop

C:\oracle\diag\rdbms\db19\db19\trace>dir | wc -l
1905

So thats 2000 trace files and I've done *no* tracing.

Perhaps post some file names for us and some sample content and we'll take a look

Rating

  (6 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

wc- l

Rajeshwaran Jeyabal, March 02, 2022 - 7:52 am UTC

could see you got "dir" there - so guess it could be a windows platform.

but, why wc-l doesn't work for us on windows platform
D:\app\Vnameit\product\21c\diag\rdbms\xe\xe\trace>dir | wc -l
'wc' is not recognized as an internal or external command,
operable program or batch file.

Connor McDonald
March 03, 2022 - 8:29 am UTC

I have windows port of many of the unix utilties.

Google for many such options

Use coreutils for wc on windows

Ramon Caballero, March 02, 2022 - 3:37 pm UTC

FYI:
https://www.gnu.org/software/coreutils/coreutils.html
Use Coreutils - GNU core utilities, to get wc and others on Windows.
Hope it helps.

Huge number of trace files are getting generated

Subbarao Dasari, March 04, 2022 - 8:53 am UTC

Thank you for your feedback

I am attaching the sample trace files is getting generated in my instance.
last two days the number of trace files generated around 40,000

files start with <sid>_j/m/o/t/d

j files are more. I don't have provision to upload files

Regards
Subbarao Dasari

Connor McDonald
March 09, 2022 - 2:25 am UTC

"j" are job queue processes. Every time you run a job, you might get a trace file indicating the job started, but take a look inside it as well. If the job fails, you also get a trace.


Huge number of trace files are getting generated

Subbarao Dasari, March 09, 2022 - 5:08 am UTC

Hi

There is no job running in my instance.

These files are generated huge in number even there is user activity on the database.

Regards

Connor McDonald
March 14, 2022 - 3:50 am UTC

Well...there area always jobs in the instance, because the *database* runs them as well

Been a long time since I used MOS

paul, March 09, 2022 - 5:01 pm UTC

But this might be a case where you want to open a ticket?

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2606144_1.html

Job Processes Fill The Filesystem With Trace Files After Installing Patch 29541742 (Doc ID 2606144.1)
Last updated on AUGUST 24, 2021

Connor McDonald
March 14, 2022 - 3:46 am UTC

+1
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.