a file on your Oracle server
of the most confounding tasks for the Oracle professional is locating
relevant file on the Oracle server. These
files include trace files needed for diagnostics, locating the Oracle
alert log file, and locating miscellaneous files on the server.
of the common uses for the file location include:
the UNIX syntax for locating files is constant on Linux, HP/UX, AIX and
Solaris, and uniform between Korn Shell Bourne shell and Bourne Again
find . –print|grep –I alert|more
dir /s alert*.log|more
the most recent files in a directory
you have located the directory for a trace or dump file, the next step is
to locate the most recent file in the directory.
ls –alt *.trc|head
can also use SQL*Plus scripts to accept values and use the SQL*Plus
“host” command to shell-out to the operating system to locate files.
Here is an example of such a script:
prompt “please enter the name of the file to find: “
host find / -print|grep –I &filename
you like Oracle tuning, you might enjoy my latest book “Oracle Tuning: The DefinitiveReference” by Rampant TechPress. (I don’t think it is right to charge a fortune for books!) and you
can buy it right now at this link: