Home Page: http://www.smenu.org
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.
There are over 91 base commands, called shortcuts, sorted by category many oft them with a fair numbers of options. In effect, Smenu acts as a repository of knowledge.
Smenu is heavily geared toward daily management and all forms of OLTP workload, including Oracle Streams on RAC.
Smenu 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
You can see Smenu in action Here: Smenu commands and make yourself an opinion.
For Cygwin install, there is a specific page Here: Smenu Cygwin
Shortcuts are usually between 2 to 4 characters long. Sourcing Smenu environment file in Smenu (. $SBIN/ad) add 91 alias. Shortcuts are sorted by category, so you don't need to learn them by heart. You only need to know one command :'sp'.
This command list all others shortcuts sorted by category this list is generated and maintained by smenu itself).
/home/oracle> sp
Administrative and miscellaneous
: 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
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
Go to [History] of smenu
Streams : [Streams_debut] [How_to_Transform_capture] [About_type_of_spilling] [How_to_see_contents_of_queues] [Update_results_in_Ora-01403] [How_to_Skip_Archived_logs] [Re-Execute_transaction] [How_to_Alter_a_rule] [How_to_drop_a_replicated_column] Logminer : [Logminer_and_XID] Tablespace : [What_is_in_tablespace] [Space.menu] [Manage_tables] Miscellaneous : [Investigate_host_hang] [Exact_scn_for_ddl] [Managing_ASM] [View_source] [Automate_partitions_in_10g] [Sql_profile]
Wiki: History
Wiki: Smenu_Cygwin
Wiki: Smenu_commands
Wiki: Space.menu