Main_Page

Anonymous Alexey Ivanov Polarski bernard

Smenu:

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.

Supported Platforms and Oracle Versions

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

View Smenu in action

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

Commands are Shortcuts

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

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

History

Go to [History] of smenu

Smenu wiki

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]

Smenu commands


Related

Wiki: History
Wiki: Smenu_Cygwin
Wiki: Smenu_commands
Wiki: Space.menu