About Trace Files

来源:互联网 发布:如何做淘宝客赚钱 编辑:程序博客网 时间:2024/05/19 13:09
##Location of Trace Files
1.trace files for background processes and the alert log :
BACKGROUND_DUMP_DEST
2.All trace files for server processes :
USER_DUMP_DEST


##Controlling the Size of Trace Files

control the maximum size of all trace files (excluding the alertlog) using the initialization parameter MAX_DUMP_FILE_SIZE

对于alert log 若想要控制其大小,需要删除之前的alert log ,否者数据库还是会在之前的alert log中追加日志,起不到控制其大小的作用。
 
   NOTE: <You cansafely delete the alert log while the instance is running, althoughyou should consider making an archived copy of it first. Thisarchived copy could prove valuable if you should have a futureproblem that requires investigating the history of aninstance.还是在删除前备份下alert log ,以备以后的诊断之用>