 |
|
|
|
| ||
| ||||||
|
|
15-10-2009 31-08-2009 28-08-2009 14-08-2009 13-08-2009 29-07-2009 29-07-2009 24-07-2009 15-07-2009 13-07-2009 10-07-2009 08-07-2009 01-07-2009 29-06-2009 25-06-2009 23-06-2009 16-06-2009 |
Added 'app -xerr -erno' Added view/re-execute errors by type (error_number) Added 'sys -io' to display avg waits on Sequential and Scattered reads, added 'lat -x' an implmentation of latchprofx Renamed 'srv -sl' to 'srv -c' and added a second session count query to display sessions count per service Added 'sx -opt' to list optimizer value for a given hash_value/sql_id Added 'prop -d <n>' to display propagation traffic during 'n' seconds Added shortcut 'rsy' to cope with all resync of streams. Added option 'spx -ls' Added shortcut 'rsy' to cope with all resync of streams, 'spx -ls' to list slave row for each master in parallel query stats Added 'sta -lr' to list when dbms_gather_stat job ran, 'sta -mod' to list tables not analyzed while they should have. Added 'lgm -w' to allow any where clause on mining archive logs Extend 'tbl -g' to partitions and subpartions Fixed some rendering in 'tbl -c' when same name is used in multiple schema. Added option 'src -st' to list system views view given string Added option 'prop -droprs' to drop rule set associated to propagation. Added option 'sq -pb' to list query with execution variations during last n days Added option 'sga -g' to list memory granule type distribution 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 mistmatch. Added , 'sq -ph' to display query performance history. Added 'sq -pb' to display query bind plan mistmatch 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 sesssions ratio on Undo/reconstruct blocks |
| 18-05-2009 | added 'idx -sinv' to generate statment 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 extrace 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 | Added option 'srv -start|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 segement 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. Addped 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 | Apdated the menu part of streams so that it to brings it in par of the shortcuts. This requieres a bit of coding to foresee multiple cases. It will allow people with less in depth knowlege 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 tanle Poder. Added 'aw -bbw' to display buffer busy wait from awr history. Added 'tbl -spc' and 'tbl -uspc' to list mapping of the blocks occupancy. Added 'tbl -dep' to list dependent segments |
| 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 dictonary. 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 | tbl -lob' display also the partitions lobs size and tablespace location of these lobs. added 'aw -dif' to create differential report on awr snapshot added 'aw -ash|-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 requiered information from data dictionary. 'prop -lat' change propagation latency and derives all its information from datadictionary. '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 informations |
| 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 requiered 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 additionals 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 showtuct '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 usefull when the latch free is on the libray cache. |
| 24-Jul-2006 | Added options -c to dsk to display comments |
| 05-Jul-2006 | Added show hidden free memory in permament 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 tablepsace '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 ... ======================================================== = Smenu 9i and 10g ======================================================== |
| Older and dreprecated features |
21-Feb-2002 : Added Capacity management to Smenu SM/2.14. This include a handy environment to gather data as well a very quick routine to produce reports. However you need to have CC or gcc, if not on the machine at least on site. Only one report type is available, more to come. More to come. 28-Jun-2001 : Add the capability to not Crypt passwd. Add a stand alone backup_hot.sh in Standalone DIR. This is the most advanced backup script I ever saw : correct Oracle 8i drop of temporary tablespaces, work with RAW of filesystem, compress on the fly and gen a according restore.sh. A must! Fix and improved 'nisx'. Add and analyse.sh in standalone DIR Add display lock by occurence (SM/2.9.8), shct 'lckc'. 15-May-2001 : Add support for locally managed tablespaces in create database script (sm/1.9) and in show tablespace ('fsi') 11-May-2001 : BPA - Fix some bugs in the warping or the stats pack ('stp'). Modified arguments for all 'tr' commands. Sun Solaris 5.8 forces the usage of the full syntax (ie tr a-z A-Z --> tr '[a-z]' ['A-Z]'. Added the support of SQLPLUS /NOLOG 22-Mar-2001 : Added failed over serssion overview, added response CPU time breakdown 30-Jan-2000 : Added support for RAW devices in backup, hot and cold. Added the support for dynamically uncompress/uzip in restore.sh scripts. Added col is autoextentd for shct 'fsi' (show tablsapces). Added a warp of statspack in 8i 'shct stp'. More work to come over statspack. Try it! Added an offensive SQL disk and hits ratio in SGA (SM 3.8.6 shct 'slo' ) 03-Jan-2001 : Modified 'sstr' so that you can put another session in trace mode just by giving its SID. Used it after a 'sl'. The possibility to put a session in trace mode just by giving its OSPID is still available. Add report ping rate (SM 2.10.5 shct 'pinr'). Add report false ping (SM 2.10.6 shct 'pinf'). Add report time to acquire PCM lock (SM 2.10.7 shct 'pint') 12-Dec-2000 : Fix some minor bugs into the menu. Some queries were accessible only through shortcuts. 24-Nov-2000 : Add a mts summary report (SM/2.12.6 shct 'mtsr'). Report session sorting (SM/2.7.9). Add some articles to wpar utility Add session wait summary (SM/3.7.8 shct 'slo') 23-Nov-2000 : Modified buffer hit ratio to include Oracle Specific calculation. This modification was required since calculation method following Oracle7 applied to oracle 8 produce false results. Report buffer pool in system (SM/3.2.10 shct 'bufr') report unindexed foreign keys (SM/2.4.4 ). Added a script to edit any Package/views/trigger/proc/funcction: (SM/1.14 shct 'qde') 16-Nov-2000 : Add report table differences in replication (SM/2.11.9.1 see shct 'rep', add run procedure rectify differences (SM/2.11.9.2). These 2 processes are quite automated and enable to quickly resync discrepancies between sites). Add Multithread server menu with 5 points (sm/2.12 shct 'mts'). Add last activity for 'sl' to reflect since when a session is inactive. Add shct 'rl' to show resource limit. 29-Oct-2000 : Add report ping in parallel server by blocks (sl/2.10.4 shct 'pib') 26-Oct-2000 : Add create a multimaster replication environement, (sm/2.11 shct rep). see : -Add view Parameters of init.ora (SM/2.1.7) and a shortcut. -Add screen of parameters for smenu and a test to generate them if they are missing (SM/1.7). -Add an install script (install.sh) that comes with the 'smenu_tar' file. It generates all needed smenu parameters in smenu.env and addpar.sh. -Add show last Redo, usefull in archive logs operations (SM/2.1.8) 14-Oct-1999 : Add data cache description & efficiency (SM/3.1.8 SM/3.1.9) add Loney tablespace index figure (SM/2.5.10), List total numbers of extents for tables and indexes (SM/2.6.6) 13-Oct-1999 : Add uptime (sm/2.1.6), resize DB gen scripts sm/1.6), list V$ views (sm/1.v), modify existing chained instructions (sm/1.3) 12-Oct-1999 : Add processing of union's in complex SQL for the instructions generator; plus fixed small bugs in the create chain process due to the additions of categories. 08-Oct-1999 : Categories of instructions are there! You may now add/export/removes categories of instructions. The introductions of Categories in instructions enable a better management of instructions when their number rise. The export category functions creates a tar file in SBIN/tmp that contains a whole category. It may be sent by email to other people and imported. This will, I hope, encourage people to exchanges they queries and instructions. All menu's that display instructions may be re-generated after every modification. Compiling menu-list of instructions, has increased display speed of these menu's from slow to immediate. 06-Oct-1999 : The instructions generator is now partially in Perl. It decodes most SQL if not all. I tried with an SQL script of 11 kb including 165 parenthesis and it survived. I have still a problem with "select * from table" as the generator relies on the fields name and aliases. The Solution is to connect to the DB and get the get fields name, but what if there are hundreds of columns, etc... Next to come. Sorry for the previous release, which was quite buggy. 28-Sep-1999 : Add instruction generator for SQL to HTML. It takes a file as argument but accept also cut and paste. May be called by shortcut (nsi). 24-Sep-1999 : Add the performance snapshot package from JLconsult and a shortcut (pf) with help on this package. The package as been totally embedded so that it is now only command lines. 23-Sep-1999 : First release |