UNIX aliases with Oracle
A UNIX alias is a short
command that is replaced with a larger command to save typing time.
For example, we could create an alias to allow us to count the
number of connected users on our oracle server:
root> alias numuse=’who|wc –l’
The whole point of UNIX
aliases is to save typing. Here is a list on common UNIX aliases
that can be added to your UNIX logon file for the UNIX Oracle user.
These aliases perform common Oracle functions such as checking the Oracle
alert log and transferring quickly between directories.
To illustrate how
useful aliases are in Oracle administration, in the example below we can
get to our pfile directory in a single command so we can view the contents
of our init.ora file:
Aliases can also be
used for sophisticated Oracle commands. For example, the following
alias can be used to display all Oracle errors in the last 400 lines of
the alert log:
If 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: