How to Delete Log Files Periodically in Oracleby Ed ChenMay 18, 2018December 10, 2022Trace 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
How to Delete Trace Files in Oracleby Ed ChenApril 4, 2018February 9, 2023Delete 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 Fullby Ed ChenApril 3, 2018April 1, 2018What 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 Filesby Ed ChenAugust 21, 2013March 31, 2018The 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