How to Delete Log Files Periodically in Oracle
Trace File, Audit File and Alert Log In this post I will introduce a shell script that can delete log files automatically. We will handle… Read More »How to Delete Log Files Periodically in Oracle
Trace Log File
How to Delete Trace Files in Oracle
Delete Trace Files Trace files have to be controlled and cleaned regularly, otherwise your disk space will be exhausted soon or later. But cleaning trace… Read More »How to Delete Trace Files in Oracle
When Oracle Software Directory Is Full
What will happen if the mount point of oracle software is 100% used or full? I guess you may feel panic due to a potentially… Read More »When Oracle Software Directory Is Full
How to Identify Key SQL Statements In Trace Files
The most important information in an Oracle trace file during debug-time is the root SQL statements that caused the dump, once you have identified the… Read More »How to Identify Key SQL Statements In Trace Files