The ability to take a basic UNIX command and
chain it with other commands is a fundamental principal in UNIX
shell programming for Oracle.
UNIX -exec and xargs commands will apply a single
UNIX command to a list of inputs. It is possible to quickly
generate a UNIX script to perform a powerful task.
Assume the goal is to create a UNIX script
that searches every file on the UNIX server for a file that contains
a reference to the dba_2pc_pending view.
The first step is to write a command that will
display all file names on the server. UNIX makes this simple:
root> find .
Now that the complete list of all of the UNIX
files is available, the UNIX xargs command can be used to search
each file for the Oracle table name in all SQL files.
This is possible because the grep commands
accepts file names as an argument.
In this case, the whole Oracle UNIX
directory structure is searched and all scripts that reference the
dba_2pc_pending view can be found.
root> find .
-print|grep sql|xargs grep -i dba_2pc_pending
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.