1. Introduction
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
This site is devoted to the management of Oracle Database, using Unix shell scripts or a Java application called 'DBAJ'.
Smenu: 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 to alter 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 accordingly.
Smenu is completely free, no charge and it is also on Sourceforge.net
4. Supported Platforms and Oracle VersionsSmenu support any platform that can handle a bash of ksh Shell. :
| Platforms |
9i |
10g |
11g |
| Linux |
Y
|
Y
|
Y
|
| Windows (Cygwin) |
Y
|
Y
|
Y
|
| Sun Solaris |
Y
|
Y
|
Y
|
| AIX |
Y
|
Y
|
Y
|
| HP-UX |
Y
|
Y
|
Y
| License: Smenu is a freeware product, you do not need any license.
5. Commands are Shortcuts 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 itself).
|
| Administrative and miscellanous |
: wpe sp wp vsh aud lsbk dbrep |
| Database, jobs |
: up rac sts vsp dblk jb shed |
| SGA |
: soc buf lc par pard sga lom |
| Stats, Logminer, statspack, trace |
: sstv sx aw xpl lgm tkp |
| Tablespaces, datafiles, transport. |
: frg lstd asm ttbl |
| Tables, index and objects sources |
: dsk src dep cpl idx tbl obj seg mod sta |
| Sessions |
: cpt mts ks sa sl lsqr dpf |
| Users and grants |
: drm rol prf |
| SQL and Undo |
: sq sqn slo st spx tx rlbs |
| Latch and enqueue |
: lck lat |
| Redo, Dataguard, Streams, Mview |
: rdl apl dg app cap rul aq prop mw rep |
| Waits, events and stats |
: sys ses sls sle ws wss wst srv | |
