SQL*Plus command line history completion

 

The rlwrap (readline wrapper) utility provides a command history and editing of keyboard input

for any other command. This is a really handy addition to SQL*Plus and RMAN .

Download the latest rlwrap software from the following URL.
http://utopia.knoware.nl/~hlub/uck/rlwrap/

Unzip and install the software using the following commands.

gunzip rlwrap*.gz
tar -xvf rlwrap*.tar
cd rlwrap*
./configure
make
make check
make install

Run the following commands, or better still append then to the “.bash_profile” of the

oracle software owner.

alias sqlplus=’rlwrap ${ORACLE_HOME}/bin/sqlplus’
alias rman='rlwrap ${ORACLE_HOME}/bin/rman'
alias expdp='rlwrap ${ORACLE_HOME}/bin/expdp'

You can now start SQL*Plus or RMAN using “sqlplus” and “rman” respectively, and you will have

a basic command history and the current line will be editable using the arrow and delete keys.

Analyze your Oracle Statspack Report

 

StatspackAnalyzer is a true expert system that seeks to codify expert DBA knowledge and advice against any

STATSPACK or AWR report. The well-structured decision rules of expert Oracle tuning specialists were collected,

quantified and then generalized and validated against real-world STATSPACK and AWR reports.

While no automated tool can fully replicate the decision processes of a human DBA tuning expert, this tool

makes observations about exceptional conditions within the STATSPACK or AWR report. This tool was never

intended to replace the human intuition of an Oracle performance expert, and all observations from

statspackanalyzer should be validated with a human expert.