Oracle Utilities - Using Hidden
Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and
More
Utility Locations
The main directories of interest regarding Oracle utilities are the
following:
$ORACLE_HOME/bin This contains the binary executables used by the
Oracle server. Most of the tools discussed in this book reside here.
$ORACLE_HOME/plsql/demo This contains a useful collection of SQL
scripts related to many utilities, including dbms_profiler.
$ORACLE_HOME/rdbms/admin This contains many SQL scripts used for
creating PL/SQL packages and their required environments.
$ORACLE_HOME/sqlplus/admin This contains scripts used with autotrace
and other utilities.
$ORACLE_HOME/otrace/admin This is the administration directory for
the Oracle Trace diagnostic tool.
$ORACLE_HOME/otrace/sysman This is used by utilities such as oemctl
and the Oracle Management Server (OMS).
$ORACLE_HOME/otrace/lib This contains facility files used with the
oerr utility.
Given the obscure location of many utilities, we need to learn how to
find them. Which utilities exist? Which ones are new?
The above is an excerpt from Oracle Utilities - Using
Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof
and More by Rampant TechPress.
For more details on Oracle
utilities, see the book "Advanced
Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.
You can buy it direct from the publisher
for 30% off directly from
Rampant TechPress.
