History

26-07-2013
Added 'sx -clr' to list sql colored (11gr2); added 'sx -clr_add' to color a new sql for monitor purpose. added 'sx -clr_drop' to remove colored sql size (RRE)

25-07-2013
Added 'lck -lo' to list object locked, with the rowid. Usefull to know which shared lock prevents a delete or table DML.

size

22-07-2013
Modified 'sta -mod' to exclude recyclin bin tables from list (RRE).

11-07-2013
Added 'frg -xt' or 'frg -id' to list hwm extend occupancy. This is usefull to list which segment to rebuild/move in order to efficient shrink datafile.

08-07-2013
Added 'rol -tbl' to list access type and user list to a table.

28-06-2013
Added 2 columns in 'lstd -fs' to give average read/write time per datafile

21-09-2012
Adapted password handling to case senstive in 11g. Added 'sga -c' to list current memory component size (11g). Added 'sga -lpar' to list parameter related to memory size

26-07-2012
Added 'tbl -wst' to list tables with too much wasted empty space. Added 'tbl -swst' to generate statement to shrink tables that wasted space

25-07-2012
Added 'sta -set_col' to set column statistics, including into partitions ( add : -part <partname>). by default the segment table is modified. Modified 'sta -get' to allow looking for column partition statistics using the '-part <partname>' clause

24-07-2012
Added 'tbl -part -s' to display columns statistics for (sub)partitions.

08-06-2012
Added 'sys -cle' to list background and foreground wait class during n secs

30-05-2012
Added 'mod -lu' to list monitored objects.

24-01-2012
Added 'sx -lpt <table_name>' to list all plan which refers to a table or one of its index.

10-01-2012
Added 'sx -po' and 'sx -po1' to show plan with steps order and additional statistics

09-01-2012
Added 'sts -dest' to list archive destinations

15-12-2011
Extended display of data value from v$sql_bind_capture to non basic type, timestampTZ, clob) using anydata access functions. this is in 'st' and 'aw'

01-12-2011
Added 'lstd -fp', 'lstd -fs' to view various files stats. Added 'lstd -d n' to view delta reads/writes during n seconds

02-09-2011
Added 'idx -lief' to list all indexes PCT internal occupancy. Added 'idx -sief' to generated statements to rebuild indexes which are below n percent occupancy.

13-07-2011
Added 'app -err -erno' to display LCR info starting from an error message number

05-05-2011
Added 'sx -fprf -id' to transfer the sql plan profile of a hinted sql (in file) to an active sql_id. Added 'sx -lot' to list the hints of a given sql_id.

28-04-2011
Added 'tbl -luse' to list top tables with low ratio of blocks usage

27-04-2011
Added 'idx -ief' to display index efficiency.

18-04-2011
Added 'sx -ld' to list all plan with different hash values. Added 'sx -cr_prf' to create a stored profile out ouf the current sql. Added 'sx -tr_prf' to transfer the SQL profile between 2 sql_id. added 'sq -lprf' to list all queries that uses store profile. added 'sx -sp' to list stored profiles in the system.

18-03-2011
Added 'seg -pread' to list segment physical read/write. Added 'seg -pread -d <secs>' to make a measurement on the segments IO during n seconds.

15-03-2011
Added 'aw -io' to display tablespace io history stats

01-03-2011
Added rac support for 'sts -sar', fixed format issue in 'tbl -p', Rename 'sx -pl' to 'sx -lpl',Added 'sx -pl' to display plan from memory when plan hash value is given.

24-02-2011
Added 'shed -a' to list jobs argument. Added 'sg -s', 'dg -t' to display various dataguard status

23-02-2011
Added support for standby redo log into 'rdl' and 'lstd'

18-02-2011
More scripts adpated to Cygwin

10-02-2011
Several scripts modified to cope with Cygwin specific. From now on, Cygwin is again my reference platform using PuttyCyg as terminal emulator.

04-02-2011
'lsbk -f' show now also the contents of archives into backup pieces that contains archives.

03-02-2011
Added 'lsbk -f' to list content of rman backup piece

28-01-2011
Added 'aw -lsm' to display General DB operations stats per snap_id, Added 'sts -fkn' to list FK on nullabe columns

24-01-2011
Added 'src -su' to display all column or source where a string appears.

20-01-2011
Added 'vsp -vv' to see parameter valid values and current set values.

12-01-2011
Added 'esqltrcprof.pl' from Norbert Debes as short-cut 'prf'. Renamed 'prf' to 'pra'.

06-01-2011
Added scrambling.ksh script, a generic routine to scramble production data for development environment

05-01-2011
Added 'frg -s' quota occupancy on tablespace overview (script by bill Hoyle). Added 'rol -usr' to display a schema detail shema role/grants (sys & objects). Added 'tbl -ctree' to list cascading FK on 'table'

04-01-2011
Added 'sta -set' to set some column statistics. Added 'sta -get' to view these values. added 'sta -cr_histo' to create a frequency histogram on a column (max 254 buckets) and adapt the density for all rows that are not in the histogram.

29-12-2010
Renamed 'aw -ev' into 'aw -se' to emphasize it is session oriented. Added 'aw -ev' to mine AWR system events & waits following various filters

23-12-2010
Added 'st -sgen' to generate usable SQL script with binds out of V$SQL and V$SQL_BIND_CAPTURE, fixed some regexp flaw in 'st -f'. Added 'aw -sgen' to extract SQL and its bind in a ready to use from AWR

21-12-2010
Added 'lgm -cr' to load archive into a table and create index. Added 'lgm -dr' to drop this table. Added 'lgm -cpt' to show counts of entries. Added 'lgm -tt -sid' to list entries for a given SID

17-12-2010
Added 'tbl -pred -col' to show plan stats for SQL that uses the column. This is especially useful to track or monitor non index columns

16-12-2010
Added 'sl -a' to see all active sessions, sql_id and the objects they access

13-12-2010
Added 'lc -mx' to show mutext distribution

10-12-2010
Added 'soc -ls' which list opened cursors per origin

09-12-2010
Added 'sx -stp' from iggy to show execution plan ordered by steps, added 'lgm -la' to mine archive directly the current redo log, Add 'lgm -sid' to mine archive per session, added 'lgm -xid' to display, All DML related to an XID.

07-12-2010
Added 'aw -slk' to display session locking tree for a given snap id.

Added 'aw -sa' to display all information related to a session for a snap, Added 'aw -ldb' to list DBID and snap counts presents in the repository, Added 'xpl -m' to generate the xplain plan for a file using DMBS_XPLAN, Added sort options to 'sx -l' to single out plans by last active, gets, cost

30-11-2010
Added 'sql -top <nn>' to produce TOP sql for <nn> secs, sorted by many conditions.

29-11-2010
Reworked 'sqn' completely in order to bring more options. check 'sqn -h' starting to modify smenu so that it may be used by non SYS or SYSTEM user with only the 'select any table and select catalog view' and exec dbms_lock.

26-11-2010
Added 'aw -sb' to list binds from AWR. Added 'aw -pf' to show SQL stats

from AWR history. revamp 'sx -l' to mine mutliple plan for a sqlid and others criterias.

25-11-2010
modified awr so that other users than sys and system may use it. Added 'aw -pl' to list plan from AWR

30-12-2009
Revamped a bit 'drm' to achieve more atomic operations. New options added.

22-12-2009
Added 'cap -d' overview of streams lines seen from source db

14-12-2009
Added 'sts -pch' to display parameter change history from dba_hist_parameter

09-12-2009
Added 'frg -cr' to generate create tablespace statement. Added 'sq -m -io' to display io waits for the last sql

26-11-2009
Added 'buf -io' to report Buffer IO distribution. Added 'srv -sti' to display service statistics per instance

24-11-2009
Added 'app -cf' to list prebuilt update conflict handler

16-11-2009
Fixed 'rol -cr' to correctly generated the creation user with grants on directories.

15-10-2009
Added 'app -xerr -erno' Added view/re-execute errors by type (error_number)

31-08-2009
Added 'sys -io' to display avg waits on Sequential and Scattered reads, added 'lat -x' an implementation of latchprofx from Tanel Poder

28-08-2009
Renamed 'srv -sl' to 'srv -c' and added a second session count query to display sessions count per service

14-08-2009
Added 'sx -opt' to list optimizer value for a given hash_value/sql_id

13-08-2009
Added 'prop -d <n>' to display propagation traffic during 'n' seconds

29-07-2009
Added shortcut 'rsy' to cope with all resync of streams.

Added option 'spx -ls' to list slave id on one row for each master in parallel query stats

24-07-2009
Added 'sta -lr' to list when dbms_gather_stat job ran, 'sta -mod' to list tables not analyzed while they should have.

15-07-2009
Added 'lgm -w' to allow any where clause on mining archive logs

13-07-2009
Extend 'tbl -g' to partitions and subpartitions

10-07-2009
Fixed some rendering in 'tbl -c' when same name is used in multiple schema.

08-07-2009
Added option 'src -st' to list system views view given string

01-07-2009
Added option 'prop -droprs' to drop rule set associated to propagation.

29-06-2009
Added option 'sq -pb' to list query with execution variations during last n days

25-06-2009
Added option 'sga -g' to list memory granule type distribution

23-06-2009
Added option 'sts -td' to convert a date to SCN, Added 'lgm -t' to list content of redo content for a given table.

16-06-2009
Added option 'app -cmp' to list compare of Old/New in apply handler for update/delete

11-06-2009
Added option 'soc -la' to list last sql's executed that are still in sql_area,

Added option 'sys -g' to show histogram of <event> taken during <n> seconds

10-06-2009
Added option 'sl -dump' and 'sl -rf' to dump session PGA and perform some aggregations.

05-06-2009
Added 'sts -s' to list system statistics, 'sts -si' to show when system statistics were taken,

'sts -' to List gather_database_stats run history. Added 'sta -fx -dx' to gather/delete stat for fixed tables. Added 'sts -fy -dy' to gather/delete system statistics.

04-06-2009
Added 'sq -pl' to display queries with multiple plan mismatch. Added ,

'sq -ph' to display query performance history. Added 'sq -pb' to display query bind plan mismatch reason.

03-06-2009
Added 'aw -gn' to list a metric stat. Use 'aw -met' to retrieve the desired metric id

25-05-2009
Added 'ses -rb' and 'sys -rb' to show sessions ratio on Undo/reconstruct blocks

18-05-2009
added 'idx -sinv' to generate statement to rebuild invalid indexes

11-05-2009
Replaced 'lck -l' with an improved version from Jared still

08-05-2009
Added option 'aw -lsi' to list relevant metric from dba_hist_sysmetric_history

07-05-2009
Added option 'aw -lst' to list most important metrics stats

06-05-2009
Added option 'tbl -txn' to list available flash back transaction for the table

05-05-2009
Added option 'sts -s' to extract Unix sar like info from AWR repository

03-04-2009
Added 'rdl -la' to display the number of log switches per hour or days

02-04-2009
Added option 'srv -st' to display various metrics on services

30-03-2009
stop|drop'. added option 'drm -set' to assign a consumer group to a user

20-02-2009
Added option 'dep -p' to list reverse object dependency

05-02-2009
Added option 'seg -top' to list top segment occupancy

23-12-2008
Added option 'shed -j' to list running jobs from scheduler

22-10-2008
Added deferrable information to 'tbl -c'

29-09-2008
Added 'aw -lbw' to list buffer busy waits stats out of dba_hist_seg_stat

16-09-2008
Added 'srv -l' to list services out from dba_services.

Added option 'prop -check' to check if propagation is ok. Added option 'prop -trace' to activate

03-09-2008
Added shortcuts 'dpf' to exploit the output table filled by 'dbms_profiler'

22-08-2008
Added option 'xpl -bu' to become another user in order to take the explain plan

18-06-2008
Adapted the menu part of streams so that it to brings it in par of the shortcuts.

This requires a bit of coding to foresee multiple cases. It will allow people with less in depth knowledge of streams to issue monitoring commands.

30-05-2008
Added 'sta -lp' to list dbms_stat default parameters

27-05-2008
Added 'rdl -t' to list redo log strands

26-05-2008
Added 'tbl -ph' to list partitions column values (high_values)

05-05-2008
Added 'aw -purge' to purge snapshots

16-04-2008
Added 'obj -lib' to list all libraries from DBA_LIBRARIES

15-04-2008
Added 'shed -e' and 'shed -d' to enable/disable a job in scheduler

Added 'shed -r' to run immediately job of of the scheduler. Added 'sta -lock/unlock' to lock/unlock table or schema statistics

28-03-2008
Added 'buf -l' to list the count of buffers of objects. Removed 'buf -a' as it is quite meaningless.

Added 'buf -drac' to list buffer objects count in all instances of RAC

27-03-2008
Added 'rac -gc' to display average Global cache block receive time.

'tbl -spc|-uspc' will now cycle through all partitions if no partition name is given

19-03-2008
Started 'rac' shortcut to re-group related queries specific to RAC

18-03-2008
Added 'sts -dif' that display parameter differences between memory and spfile

14-03-2008
Added 'buf -rac' so show cache fusion efficiency

07-03-2008
revamped 'rul' so that to better display the relations between rule sets, rules, and transformation rules

03-03-2008
Added 'sga -his' to display free SGA size history from AWR.

27-02-2008
Added 'sl -p' an adaptation of snaper from Tanel Poder.

Added 'aw -bbw' to display buffer busy wait from awr history. Added 'tbl -dep' to list dependent segments Added 'tbl -spc' and 'tbl -uspc' to list mapping of the blocks occupancy.

18-02-2008
Added 'sts -t' to convert SCN to timestamp.

Added 'obj -hd' to list location of object header block or return object whose header block is given

12-02-2008
Added 'lat -dif' to display latch statistics difference for a duration (in seconds)

05-02-2008
Added 'cap -lstb' to list suitable SCN and archive for new capture first_scn.

Added 'cap -build' to force an export of data dictionary. Added 'obj -ddl' to list last objects in DB with DDL on them.

24-Jan-2008 :
Added 'cap -pckp' to purge logmnr_restart_ckpt\$ and advance the capture SCN

23-Jan-2008
Added 'sl -t' to display impact of events on a session response time. Added 'sls -n' to list event by name and class.

22-Jan-2008
Added 'sts -opt' to display optimizer relevant parameters

16-Jan-2008
Added 'cap -gm' to display counts on all logminer tables.

15-Jan-2008
Added 'seg -hot' to list hot blocks from v$segstat. Added 'seg -tch' to list touch counts from v$segstat.

Added 'lck -t' to display locking history. Added 'sga -ko' to display overview of free chunk in SGA. This complement 'sga -k'. Added 'shed -o' to display an overview of the scheduler

11-Jan-2008 :
'sx -vstat' reports reports for each steps in an execution plan, the average value where 'sx -vlast' report the values of the last execution.

02-Jan-2008
Added 'aq -si' and 'aq -pi' to change instance queue ownership in RAC.

19-dec-2007
Added 'aq -k' to reduce the high water mark for a queue table and associated _P and IOT.

Added 'aq -qt' to list queue table real size. Added 'sls -g event name' to show event histogram

14-dec-2007
Added 'rdl -s' to display stats on redo logs. Added 'aw -f snap_id' to list snap_id's that contains the sql_id

10-dec-2007
Added 'sx -crf' to create a hint from an sql file.

Added shortcut 'lsbk' in replacement of rsbk with better scripting to list rman backups. Added 'asm -mv' to move datafile between diskgroup using rman.

05-dec-2007
Added 'sx -lso' to list all queries that uses stored outlines

04-dec-2007
Added 'sx -cro' to create stored outlines. Added 'sx -lc' to list all stored outlines Category. Added 'sx -ln' List outlines hints for a given outline name. Added 'sx -clone' to create a clone of a stored outline. Added 'sx -pos' to change the position of an hint within an outline. Added 'sx -tr' to transfer all outlines hints from a source outline to a target. Added 'sx -cl' to clear all used column in dba_outlines.used . Added 'sx -exp' to export the 3 outlines tables. Added 'sx -drc' to drop a stored outline category. Add 'sx -dr' to drop a single outline.

03-dec-2007
added 'aq -purgep' to remove all rows from given exception queue. Added 'aw -prf <sql_id>' to generate an SQL profile. Added 'aw -lprf' to generate list of sql profiles. Added 'aw -llprf' to show report for an Advisor task

28-Nov-2007
Added code to open an read exception queues in 'aq -readp'. We now support descriptions of SYS.LCR$_PROCEDURE_RECORD. No doubts, your life is changed

23-Nov-2007
Added options 'aw -reset, -ckf, -chk, -cpt' to set/unset various capture parameters

22-Nov-2007
Added 'aq -readp <queue_name> -key' which display all values for a transaction in normal and exeption table queues (AQ$_<xx>_P)

19-Nov-2007
Added 'aw -xpf' to extract from AWR sql_id whose plan differ from v$sql_plan added 'aw -sp' to extract explain plan for a given snap_id. add option 'sx -i' to extract plan from v$sql_plan with and sql_id

15-Nov-2007
Added 'sts -f' to show how much free space is left in the flashback area

09-Nov-2007
Added 'rlbs -us' to Show the number of undo megs tablespace needed in the system following average usage in the past. Added 'aw -sl' to extract top heavy sql load in system from AWR. added 'aw -t <sql_id>' to submit sql_id to advisor and output results. This creates, run, display and drop the task. added 'aw -ad' for a given period to obtain advices over this period

08-Nov-2007
-sid' to create active session reports for all or a single session. Added 'aw -s' to view all info including explain plan from awr history

06-Nov-2007
Added option 'aw -set' to set workload repository duration and interval

02-Nov-2007
Added option 'aw -b/-e' to produce awr report between 2 given snap id. added option 'aw -html' to produce reports in html, default is text. Added option 'frg -os' to list objects in tablespace and their size. Useful to see lobs real size

31-Oct-2007
added 'shed -log' to show log for dba_scheduler_job_log. Enriched the display of 'shed -l' to list additional info on schedules, program and generated jobs

30-Oct-2007
dded option 'mod -x' to force refresh dbms_stat info on dba_tab_modifications

29-Oct-2007
added 'mod' to show result from monitoring tables modifications from dba_tab_modifications

26-Oct-2007
Added 'awr' which will contains all about awr. Added 'awr -l' to list available snapshots,options '-use' list the awr options used on this DB(License?). added option 'awr -r' to produce awr report on last snap

25-Oct-2007
Added options 'tbl -logu' to list tables supplemental group not based on FK,PK or bitmap. Added 'prop -rcr' to recreate a propagation will deduce now all required information from data dictionary. 'prop -lat' change propagation latency and derives all its information from data dictionary. 'prop -v' will show last enqueue SRC scn and last TARGET dequeued scn.

17-Oct-2007
Added 'obj -dir' to list oracle directories from dba_directories

15-Oct-2007
Added shortcut 'shed' to service all about scheduler, added view supplemental logging with 'tbl -log' , Added List, disable, enable constraints for a table or schema 'tbl -cl -cd -ce

14-Oct-2007
Short cuts 'cap','prop','rul,'app','aq' enriched with alots of specific 10gr2 streams functions

09-Oct-2007
Added ASM shortcut to see ASM information's

24-Aug-2007
'tbl -l' also report now the size and internal occupancy for lobs

13-Aug-2007
Added new calculation method for clustering factor into 'idx'. Added some more options in 'obj' to view objects (per user, id)

10-Aug-2007
Added 'sta -lst' to list objects without statistics added option -heavy_disk and -heavy_gets to 'sq' to list heavy sql. This is an alternate to option 'load' or -b or -d options. added generation of index creation statements when asking a table creation script with 'tbl -ddl'

24-Jul-2007
Added 'rob -c' to generate creation script for a given role. Added 'roa -c' to generate creation script for a given user

20-Jul-2007
Modified "sta" so that sm_sttab is not more required to gather statistics. Added support for MV in 'src', it does same thing as 'mw -t' : output source code. Added support for trigger into 'src'

10-Jul-2007
Added 'xpl -b' to show plans using dbms_xplan with 6 additional options

08-Jul-2007
Added shortcut 'fio' to list datafiles io waits

14-Jun-2007
Added 'mw -c' to list materialized view refresh group. Added one column to 'fsi' to show tablepsaces with one extent segment that will failt to extend. Added option 'xt' to 'obj' to display the object with not enought space to extent

11-Feb-2007
Added shorcut 'dep' options to list object dependencies

31-Jan-2007
Added 'sq -pk' to list running PL/SQL packages 02-Dec-2006 : Added option -pred to 'tbl' to show col_usage$. This allow to known which column is used with which type of joins on predicate

15-Dec-2006
Added view upload errors from EM sysman tables

03-Nov-2006
Added sampling of v$session_event and 2 options to spl in order to the profile for a session, module or action

26-Oct-2006
Added shortcuts 'mts' to deal with MTS, see mts -h. Added 'sl -lw' for 10g to display in one screen active session, sql, the wait and object locked. added option in 'rep' to set up 'repadmin' and 'snapadmin' accounts

23-Oct-2006
Added option -f to 'idx' so that it displays indexed column for fixed views

20-Oct-2006
dded option -ff to retrieve fast segment name when given file_id and block_id. Though it works only locally managed tbs, it is around hundreds times faster than traditional way as it avoid access to dba_extents

17-Oct-2006
Added display non-idle time to 'sl

10-Oct-2006
Added option -ext to 'dblk' in order to add info from v$dblink, added option -a to cpt to also list accounts without any objects. Added shortcut 'mw' to handle everything regarding materialized views. It should grow until all is covered on the same par that streams family of shortcuts.

04-Oct-2006
Added 'sq -sp' and added the notion of family sql for sql without bind variables. This will be exploited later to help identify who weight on the DB even if sql hash_values are scattered. Perl sampler back ported to 8i and made more robust and stable for long running (days). Added some option to 'spl', fixed a bug in image maker with certain combinations of selections to display that causes the title to disappear.

28-sep-2006
added to 'tbl' option -i to gives all info from dba_tables, easy and so convenient.

25-sep-2006
Added 'sq -load' in an attempt to single out heavy sql not using binds

21-Sep-2006
Added 'buf-i' to show info contained into x$kvit

15-Sep-2006
added option -rec to (rlbs) to see number of vector changes per objects in RLBS. extended (sl) with -r and -o to list overview of session and list who is running SQL at this moment.

14-Sep-2006
Modified 'dsk' so that it shows also X$ table in partial name selection, added 'soc -sa' to display cursors not shared and the reason. Added support of 10gr1 to 'aq'. Added option -sa to 'soc' to display cursors not shared and the reason. added support of 10gr1 to 'aq'.

13-Sep-2006
Added option ses to see session statistics, plus diff of stats for a given period

12-Sep-2006
Added option sys to see system statistics, plus diff of stats for a given period

06-Sep-2006
Added options to 'lat' to process 'cache buffer chain', added options to list segment and options covered by a children latch in x$bh. updated 'lat' with option -mis to show latche misses location. updated 'obj' with option -dict to list object out of 'DICT' even given partial name

04-Sep-2006
Regrouped all shortcuts 'buf?' into single 'buf' with options. optimized some of these options. Optimized 'dus' shortcuts for better performances

24-Aug-2006
Added some options into smenu_get_passwd so that it allows distinct user connection

22-Aug-2006
Added option -e to 'lstd' to list datafile in auto that cannot extend anymore

06-Aug-2006
Add options to 'lc' to show who is holding the library cache pin and what is locked

27-Jul-2006
Fix a small bug in aud that did not filter user when filter is requested and user name given in lower case. Regrouped all 'lck%' shortcuts into 'lck' added the shortcut 'seg' to address v$segment_statistics

25-Jul-2006
regrouped all latches related shortcuts into a single one 'lat'. Added some more options to 'lat' such as latch location, sub pool latch count. Added option -d to 'par' to show better details on system parsing. This is useful when the latch free is on the library cache.

24-Jul-2006
Added options -c to dsk to display comments

05-Jul-2006
Added show hidden free memory in permanent memory for 'sga'. Added option -f to 'src' to show text from fixed_view_definition in order to have the SQL text for the x$ views.

03-Jul-2006
'sp' will list shortcuts sorted by categories. 'lc -b' will show who is holding the library cache lock and session waiting.

28-Jun-2006
Add link to v$sql_bind_capture into 'sx', add converted options hash_value sql_id so sx, added to sx automated generation of 10053 or ""nnn" event with automated retrival and display of the trace file.

21-Jun-2006
sw' will also now report mem_used from v$sql_workarea_active and spilled to disk tempsegs.

20-Jun-2006 :
Added advices lookup in SGA and extended sga summary (sga -s)

18-Jun-2006
added session pga memory usage (lc -ses)

15-Jun-2006
Added usage for temporary tablespace 'dus -t'

08-Jun-2006
Add dbms_xplain to the options of 'sx'. added blocks in 'tbl -t', usefull when considering clustering factors in 'idx -i'. added some options to src to show what object type is behind the synonym.

06-Jun-2006
Added par -s to show parsing per session, added -e "<event>" to to 'sle' to display all sessions whitch sharer this events

02-Jun-2006
Renamed lcp to 'lc' and added some info for the library cache. Usefull to know the reload and invalidation ongoing. added list of current running cursor to 'soc'

29-May-2006
Added a specific query for library cache pin (SM/2.7.20) shortcut 'lcp'

23-May-2006
Added option -like to dsk to list existing objects of this type Added option -a to option sx to show predicate and access values.

02-May-2006
Renamed shortcut pkg to src, as it will also show the source for views.

25-Apr-2006
Added option -t to 'soc' so that to report only text for a given SID. added also option -h to 'soc'. Added the shortcut 'tx' to deal with in doubt transactions. It has 3 options to query v$transaction, dba_2pc_pending and neighbors.

10-Apr-2006
Added a Perl sampler to be called for remote DB.

12-Apr-2006
Added option 'prf' to list profile by name (-l) or to list all attribute for a single profile (-p). Added opiont -m to 'aud' to that to list last logon time for a user. Add list all user with a given profile 'prf -p PROFILE -lu'

11-Apr-2006
Added in spl the grouping by all type of minutes in individual SQL_HASH report added the capability to limit the rows in this case. With the option -min, to go back in timle,the number of rows filter and the grouping by time You can extract any report for any query for any duraton on any time frame and produce a graphic of it

08-Apr-2006
Added a install step by step in the online manual on how to add graphics New options on the spl, mainly all that deals with ratio among the raw data. All these options can now be pushed to graphic. spl -x -g -w -r etc.. Start the work on detailed activity per time for an SQL, say minutes by minutes behaviour of a given SQL and push it to graphic ('spl -de')

05-April-2006
First graphic added to 'spl' with option -m. For the moment only 'spl -dx', -dr, -dd, -dg are supported. Access this option with spl -img. You must have firefox in the path.

28-Mar-2006
Added shortcut 'dg' for logical dataguards with plenty options to view differents stats : -e for errors, -a apply status, -m monitor etc

23-Mar-2006
Modified install.sh and docs so that smenu can run now on Cygwin

16-Mar-2006
Added -u to 'rob' so that to list user which have the role in argument

13-Mar-2006
Added auto-probe library to run perl DBIx. this is the first stage of SQL to pie and bart charts I intend to add in Smenu for nice reporting on the Oracle wait Interface implementation in Smenu

01-Mar-2006
Added single user display roles to 'roa' added rog, to display privileges for one role

08-Feb-2006
Added options -tx, -d to 'rlbs' to monirot who is holding the undo segments. Added 'lstr' to return queries with containt a substring. Very usefull to set session to trace when you hunt for values for bind variables. Added 'cpl' to list statement to compile invalid objects and list last modified objects

04-Jan-2006
Added show higher applied logs 'apl -m' 03-Jan-2006 : Merged the shortcut 'owi' into 'spl'

01-Jan-2006
Added A full set of command for streams and a section on setup streams in the manual. There a 5 shortcuts for streams 'aq','cap','prop','app','rul'. Each of them comes with an help. Moved the web site from geocities to www.smenu.org

13-Dec-2005
Started to add implmentation of Streams in smenu. this is a big addition that will keep me busy for some weeks. SM/3.8, shortcuts are 'cap', 'prop','app','aq'.

17-Sep-2005
Years! I was away from Oracle during this period and Smenu suffered alot. I am now back on track, got my 10g certification and started a whole reshuffle of Smenu. Looking backward, I realize how weak was my knowledge. I, since, studied alot the engine, read even more, and with the knowledge came the will to make of Smenu something correct. No more diaries of figures, Smenu focus now on two directions : help DBA in their daily routine and spot problems, link them to solutions, while remaining fast and efficient. I removed the backup section since Rman is so good and easy to use with the DB console in 10g. Many shortcuts were suppressed, being found useless or their specificity merged into more relevant one. Wpar utility is expanded to higher levels as it contains the advice to solve spotted problems. To follow ...