Square DBA – Oracle DBA Talk

Changing the location of trace files

The location of Oracle trace and log files can be changed.  I normally recommend leaving them in the default location, but there are reasons to put them somewhere else. In SQLPlus type:

show parameter

This will display all of the non-hidden parameters.  Generally any of these can be modified with a ALTER SYSTEM or ALTER DATABASE.  Remember you will need to set the scope.  SCOPE=SPFILE; SCOPE=MEMORY; or SCOPE=BOTH;