Since Oracle 11g, RDBMS diagnostic data has been reorganized and is stored inside a common directory structure, the Automatic Diagnostic Repository (ADR). An ADR is a centralized directory structure where one can find trace files, alert messages, incident dumps, core files, etc. And a comand line tool ADRCI can be used to mange this repository. … Continue reading Which user to run ADRCI? →

In my last post, I've showed how to purge Audit Trail files from OS. Usually Audit Trail directories are places which you see lots of space used due to unmanaged audit files from Oracle. However, there are places you may want to take a look when you see a filesystem related to Oracle is getting … Continue reading Purging flat (non-XML) text listener log file for ASM, SCAN etc. →