Trace files can be generated at the user's request.
Printable View
Trace files can be generated at the user's request.
Sorry, but what trace files are we talking about, actually?
By Default, Oracle generates the following trace files:
background dumps in $ORACLE_HOME/admin//bdmp/
core dumps in $ORACLE_HOME/admin//cdump/
user dumps in $ORACLE_HOME/admin//udump/
The files in these directories have stopped being generated. I have verified (or updated) the system parameters previously suggested, but to no avail.
Those are the trace files in question:)
Ok, in normal operation, you only have alert.log in your bdump.
In case of failures of background processes you can also get trace files with error information in bdump.
If you have SQL_TRACE=true on system level, you get trace file for every single session in your udump directory. Or one trace, if you have turned it on on session level.
In cdump Oracle dumps core (memory image of process) if strange, invalid situation occurs.
So, do you have your alert.log?
Yes, i have my alert.log file. SQL_TRACE = TRUE, so I should be getting other files in there, but I'm not.
Don't worry if you don't get trace files. Its normal. Whenever there is a trace file your alert log makes an entry saying there is trace file.
You have to worry only when your alert log says there is trace file and you can't see that trace file.
So, bdump is ok.
If you connect to database and issue some queries, you should get session's trace file in udump destination, provided that udump parameter is well set.
I udump dest is ok, but no trace file, try 'alter session set sql_trace = true'.
??? Any success ???
I have those parameters set, and I log into the database, issue queries, etc... but no files get generated.
I have set:
shadow_core_dump = FULL
background_core_dump = FULL
in init.ora, but that didn't help either.
When I perform actions that would normally generate trace files, they don't.
I neglected to mention the reason that I want these files: I need them to do application performance tuning.
no way you are gonna set that to true in a normal databaseQuote:
Originally posted by Sameer
Has Anybody stopped generation of trace files by changing SQL_TRACE parameter?
Is SQL_TRACE still TRUE
check
SQL> show parameter sql_trace
Sameer