Visit Smenu wiki: http://sourceforge.net/apps/mediawiki/smenu/index.php?title=Main_Page
Smenu in Action : https://sourceforge.net/apps/mediawiki/smenu/index.php?title=Smenu_commands
site is devoted to the management of Oracle Database,
using Unix shell scripts or a Java application called 'DBAJ'.
Smenu is a Selection of Unix, SQL and PL/SQL scripts, sorted by
category. It is used from outside the DB as a regular Unix command. Smenu manage
the connection to
the DB and executes a predefined SQL and the
result is output on the screen. Shortcuts allows allots of optional parameters
execution. With the help of cut of paste, out results from one scripts
becomes the input of another one. This allow a level of drill down and data
mining in all directions. There are over 127 base commands sorted by category and
the whole amount to a huge numbers of options. In effect, Smenu acts as a
repository of knowledge. Smenu is heavily geared on daily management and all
forms of OLTP workload, including Oracle Streams which is the author specialty.
2. Source of Smenu
Half of the scripts in Smenu comes
from publication on books, articles and blogs. Whenever possible, we always kept
the name of the author. Our role is one of selecting the best and adapting it to
Smenu. Here and there we have supplied missing features to cover as much as
possible all aspects of the daily tasks of a production DBA job.
3. Why use Smenu ?
Because Smenu is simple to install, simple to use, simple to
maintain but id does not prevents Smenu to offer advanced features not to be
found in grid control.
Learning the Oracle DBA job is not too difficult, but keeping
alive in your memory all what you ever encountered is near impossible. Though,
what you encounter today, may come back anytime in the future. Will you remember
exactly your analysis? The best practices is to save your current work into a
script for later reuse within a category of files that you have classified
Smenu is completely free, no charge and it is also on
Platforms and Oracle Versions
Smenu support any platform that can handle a bash of ksh Shell. :
a freeware product, you do not need any license.
We try to keep the command very short, usually
between 2 to 4 characters length, for this reason we named them 'shortcuts'. You
load the 127 shortcuts by sourcing an environment file your
root Smenu directory (. $SBIN/ad). Since the shortcuts are sorted by category you don't need to learn them by
heart, this will
come with usage. You only need to know one command to start :'sp'.
This command list all others
shortcuts sorted by category this list is generated and maintained by Smenu
|Administrative and miscellanous ||:
|Database, jobs ||:
|Stats, Logminer, statspack, trace ||:
|Tablespaces, datafiles, transport. ||:
|Tables, index and objects sources ||:
|Users and grants ||:
|SQL and Undo ||:
|Latch and enqueue ||:
|Redo, Dataguard, Streams, Mview ||:
|Waits, events and stats ||: