On 11G user and system traces are on the same directory (%DIAGNOSTIC_DEST%\diag\rdbms\SID\trace on my machine) and automatic health monitoring looks like a bit more active than 10G. On 10G I wasn’t seeing automatic trace generation for user sessions, however on 11.1.0.6 Oracle nearly creates trace for every session and it realy drives me mad when I am working on 10046 traces. I checked unsupported parameters and I found _disable_health_check parameter. When you set this parameter to TRUE a Oracle stops generating trace files for every user session. Parameter needs restart of database.
It looks like there are 32 other diagnostic related parameters on 11G but _disable_health_check
was enough to solve my problem.
I can see this parameter is available on 10GR2 and 11GR1 but not available at least on 9.2.0.4
!!!!! As you see, it is unsupported dont use it on any production system without asking Oracle Support.
What were the names of the trace files?
Have you found a way of inhibiting trm files yet in 11g. It is rather frustrating generating twice the files you need and we are not likely to use the XML format.
Comment by John Hallas — June 3, 2009 @ 3:31 pm
They are all trace and trm files but at least after changing this parameter I dont get auto traces for every user session. Background session trace still continues with boh trm and trc files.
TRM files are more than annoying but I have no solution for them. I think They should at least put them to separate directory. It is very hard to find your file in this new architecture unless you have a tracefile identifier.
Comment by coskan — June 3, 2009 @ 3:37 pm
Trm files are yet another thing to make something simple more complex
. First alert log gets changed to XML and to read it, comes a magical util ADRCI and then comes these TRM files which according to oracle are used to search the actual trace files! Huh? Why not let the trace be, well, just good-ol trace only?
Ok rant over
.
Aman….
Comment by Aman.... — July 14, 2009 @ 6:31 pm
Magical steps to Self managed database
)
Comment by coskan — July 14, 2009 @ 9:22 pm