| |
 |
|
Oracle Tips by Burleson Consulting
|
Locate recently created UNIX
files
The following command is useful for finding UNIX files that have
been recently added to your server. Part of the job of the Oracle
DBA is monitoring the background_dump_dest and the user_dump_dest
for trace files, and purging trace files that are no longer
required.
The following command lists all files that were created in the past
two weeks:
root> find . -mtime -14 -print
.
./janet1_ora_27714.trc
./janet1_ora_27716.trc
./janet1_ora_24985.trc
./janet1_ora_24977.trc
This command can easily be expanded with the xargs or the –exec
command to automatically remove the elderly trace files:
root> find . -mtime -14 -print|xargs -i
rm \;
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
