Be the first to post a text review of Shell environment for oracle. Rate and review a project by clicking thumbs up or thumbs down in the right column.

View all reviews

• Forum thread added

  joanywhere created the CSV Output forum thread

  posted by joanywhere 133 days ago

• senora-production Senora-1.0.1 file released: SenoraDoc.html

  * 20.05.2003 10:10 Fixed grep command to ignore LONG columns * 02.10.2003 09:35 Added possibility to login as sysoper or sysdba (require DBD-Oracle for oci8 * 06.10.2003 17:13 Fixed bug in profiler: did not separate reported statements properly. * 07.10.2003 18:50 Fixed problem login in without service name. Problem was detected by Ganesh R on sourceforge. The fix was by anonymous also on sourceforge * 07.11.2003 09:42 Changed "space -d" for better performance on Oracle9 * 16.01.2004 16:58 Ireland Changed get serveroutput, so nothing is done if serveroutput is off * 21.01.2004 14:08 truncated number of decimals in ps -l command * 03.03.2004 09:44 System tools read registry to get ORACLE_HOME * 16.03.2004 18:49 Fixed error running a script from cmdline * 17.03.2004 00:08 added /nolog option Fixed many problems when running scrips Fixed handling of /* ... */ comments in a single line * 17.03.2004 16:32 Made all settings case insensitive. * 18.03.2004 16:00 Removed Quotes from defines * 06.05.2004 11:18 Added reporting of fetch errors like in "select 1/0 from dual;" * 10.05.2004 09:29 moved dropAll from Sqlplus.pm to Reorg.pm * 19.05.2004 13:51 Added chipach's change to ignore idle wait events Added chipach's for readline (exit ob newline) Provided a way to connect without password and then prompt for it (This requires Term::ReadKey and does not work in Emacs shell-mode) Fixed push/pop of settings. Revamped the machnism altogether Fixed Template command to include use SessionMgr qw(sessionNr sql); * 08.06.2004 12:16 SPL sortplan interface Fixed DropAll so lowercase objects can be dropped Upgraded to perl 5.8.3 so I could use the driver from ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-Oracle.ppd get better error messages now. Got a new perl2exe (paid!) Beautified chacheStats a bit (still ugly) * 02.07.2004 14:27 Changed the "refs" command so only tables are shown and not table parititions. * 08.07.2004 11:43 Added table and column comments to "describe" table * 19.10.2004 16:11 Fixed CREATE TRIGGER which was not recognized as plsql * 24.11.2004 11:34 Added Tuning::openCursors Added Tuninng::alertLog to look at the alert log from the instance This uses external tables (9i only) or utl_file. Very slow on large alert logs and somewhat experimental * 30.11.2004 10:23 Added better error reporting in profiler. * 02.02.2005 11:07 Fixed SqlSession::execute so no exceptions are raised and the error messages look nicer. * 19.10.2005 11:07 Fixed define command so definition can contain equals sign * 15.12.2005 10:08 Started using GV$ views instead of v$ so "ps" works with a cluster xxx unfinished ! * 16.01.2006 16:50 Added "Used" space columns to space command * 23.01.2006 18:29 Added SystemTools.genDrops to generate drop statements from CREATEs * 16.03.2006 15:29 Added PURGE as accepted SQL command starter Renamed the internal purge command to "chop" * 28.03.2006 10:56 Added hash value output to xplain so execution plans can be compared for equality easily * 04.05.2006 09:29 Fixed ps command to work on a cluster, using the GV$ views. Changed the default ordering of "ps" output, so heavy session are displayed last (if -l option is used) * 29.05.2006 16:24 Obsoleted FdStack. Made sure at startup login.sra or login.sql is run but not both. * 29.05.2006 16:25 Added LegacySql and examples. This allows you to use legacy scripts (including Oracle's admin scripts) as senora commands. * 31.05.2006 09:42 Made currentStatement cluster aware (GV$ views Made waits cluster aware) * 06.07.2006 16:16 CH REMA tuning Added timings to sql output like Elapsed: prepare+execute = 10 msec; fetch= 3220 msec; total= 3230 msec * 01.09.2006 14:48 Made "locks" cluster aware * 14.03.2007 16:13 Current Statement can now show the real(!) execution plan * 15.03.2007 13:24 Renamed stat to sesstat and anas to stat Improved dbms_stats wrapper ("stat") Added "set nop" for better testing * 16.03.2007 09:02 Added "edit" option for tnsnames * 03.04.2007 14:55 Fixed jobs -r (Broken='Y', not 'T') Fixed small bug in explain plan of current statement * 10.05.2007 15:19 Fixed small bug in desc -l * 15.06.2007 12:49 Fixed "set drop errors" * 19.06.2007 10:21 Added -v option to "ls" (exclude names) * 03.07.2007 10:02 Convert binary doubles into integer to e.g. display "4" instead of "4.0E+000" by default * 29.08.2007 11:22 Added DataDictionary.codeLine to view selected parts of source code * 12.09.2007 09:49 Added options -A (active) -U (user sessions) to ps command# * 19.02.2008 13:27 Fixed bug in Tuning.currentStatement: it showed the prev statement when asked to also show the execution plan. * 03.03.2008 14:26 Disabled readline support for Windows. A Backspace caused access violation when compiled with perl2exe * 17.04.2008 09:39 Changed the rebuild_indexes (rix) command so partitioned indexes are properly handled * 04.08.2008 13:53 Fixed small bug in SystemTools.genDrop * 04.11.2008 10:19 Added -s option to openCursors to show only one SID * 08.01.2009 11:54 Added the possibility to change the PATH and ORACLE_HOME via an "environment" file to simply using different Oracle versions without having to write a wrapper batch file. This also helps running Senora on 64 bit systems, if you install a 32bit Oracle Instant Client.

  posted 241 days ago

• File released: /senora-production/Senora-1.0.1/SenoraDoc.html

  posted 241 days ago

• Project Information Updated

  drautzburg changed the public information on the Shell environment for oracle project

  posted by drautzburg 241 days ago

• Senora 1.0.1 is out

  This is the first production release.

  posted by drautzburg 241 days ago

• senora-production Senora-1.0.1 file released: senora101.tgz

  * 20.05.2003 10:10 Fixed grep command to ignore LONG columns * 02.10.2003 09:35 Added possibility to login as sysoper or sysdba (require DBD-Oracle for oci8 * 06.10.2003 17:13 Fixed bug in profiler: did not separate reported statements properly. * 07.10.2003 18:50 Fixed problem login in without service name. Problem was detected by Ganesh R on sourceforge. The fix was by anonymous also on sourceforge * 07.11.2003 09:42 Changed "space -d" for better performance on Oracle9 * 16.01.2004 16:58 Ireland Changed get serveroutput, so nothing is done if serveroutput is off * 21.01.2004 14:08 truncated number of decimals in ps -l command * 03.03.2004 09:44 System tools read registry to get ORACLE_HOME * 16.03.2004 18:49 Fixed error running a script from cmdline * 17.03.2004 00:08 added /nolog option Fixed many problems when running scrips Fixed handling of /* ... */ comments in a single line * 17.03.2004 16:32 Made all settings case insensitive. * 18.03.2004 16:00 Removed Quotes from defines * 06.05.2004 11:18 Added reporting of fetch errors like in "select 1/0 from dual;" * 10.05.2004 09:29 moved dropAll from Sqlplus.pm to Reorg.pm * 19.05.2004 13:51 Added chipach's change to ignore idle wait events Added chipach's for readline (exit ob newline) Provided a way to connect without password and then prompt for it (This requires Term::ReadKey and does not work in Emacs shell-mode) Fixed push/pop of settings. Revamped the machnism altogether Fixed Template command to include use SessionMgr qw(sessionNr sql); * 08.06.2004 12:16 SPL sortplan interface Fixed DropAll so lowercase objects can be dropped Upgraded to perl 5.8.3 so I could use the driver from ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-Oracle.ppd get better error messages now. Got a new perl2exe (paid!) Beautified chacheStats a bit (still ugly) * 02.07.2004 14:27 Changed the "refs" command so only tables are shown and not table parititions. * 08.07.2004 11:43 Added table and column comments to "describe" table * 19.10.2004 16:11 Fixed CREATE TRIGGER which was not recognized as plsql * 24.11.2004 11:34 Added Tuning::openCursors Added Tuninng::alertLog to look at the alert log from the instance This uses external tables (9i only) or utl_file. Very slow on large alert logs and somewhat experimental * 30.11.2004 10:23 Added better error reporting in profiler. * 02.02.2005 11:07 Fixed SqlSession::execute so no exceptions are raised and the error messages look nicer. * 19.10.2005 11:07 Fixed define command so definition can contain equals sign * 15.12.2005 10:08 Started using GV$ views instead of v$ so "ps" works with a cluster xxx unfinished ! * 16.01.2006 16:50 Added "Used" space columns to space command * 23.01.2006 18:29 Added SystemTools.genDrops to generate drop statements from CREATEs * 16.03.2006 15:29 Added PURGE as accepted SQL command starter Renamed the internal purge command to "chop" * 28.03.2006 10:56 Added hash value output to xplain so execution plans can be compared for equality easily * 04.05.2006 09:29 Fixed ps command to work on a cluster, using the GV$ views. Changed the default ordering of "ps" output, so heavy session are displayed last (if -l option is used) * 29.05.2006 16:24 Obsoleted FdStack. Made sure at startup login.sra or login.sql is run but not both. * 29.05.2006 16:25 Added LegacySql and examples. This allows you to use legacy scripts (including Oracle's admin scripts) as senora commands. * 31.05.2006 09:42 Made currentStatement cluster aware (GV$ views Made waits cluster aware) * 06.07.2006 16:16 CH REMA tuning Added timings to sql output like Elapsed: prepare+execute = 10 msec; fetch= 3220 msec; total= 3230 msec * 01.09.2006 14:48 Made "locks" cluster aware * 14.03.2007 16:13 Current Statement can now show the real(!) execution plan * 15.03.2007 13:24 Renamed stat to sesstat and anas to stat Improved dbms_stats wrapper ("stat") Added "set nop" for better testing * 16.03.2007 09:02 Added "edit" option for tnsnames * 03.04.2007 14:55 Fixed jobs -r (Broken='Y', not 'T') Fixed small bug in explain plan of current statement * 10.05.2007 15:19 Fixed small bug in desc -l * 15.06.2007 12:49 Fixed "set drop errors" * 19.06.2007 10:21 Added -v option to "ls" (exclude names) * 03.07.2007 10:02 Convert binary doubles into integer to e.g. display "4" instead of "4.0E+000" by default * 29.08.2007 11:22 Added DataDictionary.codeLine to view selected parts of source code * 12.09.2007 09:49 Added options -A (active) -U (user sessions) to ps command# * 19.02.2008 13:27 Fixed bug in Tuning.currentStatement: it showed the prev statement when asked to also show the execution plan. * 03.03.2008 14:26 Disabled readline support for Windows. A Backspace caused access violation when compiled with perl2exe * 17.04.2008 09:39 Changed the rebuild_indexes (rix) command so partitioned indexes are properly handled * 04.08.2008 13:53 Fixed small bug in SystemTools.genDrop * 04.11.2008 10:19 Added -s option to openCursors to show only one SID * 08.01.2009 11:54 Added the possibility to change the PATH and ORACLE_HOME via an "environment" file to simply using different Oracle versions without having to write a wrapper batch file. This also helps running Senora on 64 bit systems, if you install a 32bit Oracle Instant Client.

  posted 241 days ago

• File released: /senora-production/Senora-1.0.1/senora101.tgz

  posted 241 days ago

• senora-production Senora-1.0.1 file released: SenoraForWindows101.zip

  * 20.05.2003 10:10 Fixed grep command to ignore LONG columns * 02.10.2003 09:35 Added possibility to login as sysoper or sysdba (require DBD-Oracle for oci8 * 06.10.2003 17:13 Fixed bug in profiler: did not separate reported statements properly. * 07.10.2003 18:50 Fixed problem login in without service name. Problem was detected by Ganesh R on sourceforge. The fix was by anonymous also on sourceforge * 07.11.2003 09:42 Changed "space -d" for better performance on Oracle9 * 16.01.2004 16:58 Ireland Changed get serveroutput, so nothing is done if serveroutput is off * 21.01.2004 14:08 truncated number of decimals in ps -l command * 03.03.2004 09:44 System tools read registry to get ORACLE_HOME * 16.03.2004 18:49 Fixed error running a script from cmdline * 17.03.2004 00:08 added /nolog option Fixed many problems when running scrips Fixed handling of /* ... */ comments in a single line * 17.03.2004 16:32 Made all settings case insensitive. * 18.03.2004 16:00 Removed Quotes from defines * 06.05.2004 11:18 Added reporting of fetch errors like in "select 1/0 from dual;" * 10.05.2004 09:29 moved dropAll from Sqlplus.pm to Reorg.pm * 19.05.2004 13:51 Added chipach's change to ignore idle wait events Added chipach's for readline (exit ob newline) Provided a way to connect without password and then prompt for it (This requires Term::ReadKey and does not work in Emacs shell-mode) Fixed push/pop of settings. Revamped the machnism altogether Fixed Template command to include use SessionMgr qw(sessionNr sql); * 08.06.2004 12:16 SPL sortplan interface Fixed DropAll so lowercase objects can be dropped Upgraded to perl 5.8.3 so I could use the driver from ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-Oracle.ppd get better error messages now. Got a new perl2exe (paid!) Beautified chacheStats a bit (still ugly) * 02.07.2004 14:27 Changed the "refs" command so only tables are shown and not table parititions. * 08.07.2004 11:43 Added table and column comments to "describe" table * 19.10.2004 16:11 Fixed CREATE TRIGGER which was not recognized as plsql * 24.11.2004 11:34 Added Tuning::openCursors Added Tuninng::alertLog to look at the alert log from the instance This uses external tables (9i only) or utl_file. Very slow on large alert logs and somewhat experimental * 30.11.2004 10:23 Added better error reporting in profiler. * 02.02.2005 11:07 Fixed SqlSession::execute so no exceptions are raised and the error messages look nicer. * 19.10.2005 11:07 Fixed define command so definition can contain equals sign * 15.12.2005 10:08 Started using GV$ views instead of v$ so "ps" works with a cluster xxx unfinished ! * 16.01.2006 16:50 Added "Used" space columns to space command * 23.01.2006 18:29 Added SystemTools.genDrops to generate drop statements from CREATEs * 16.03.2006 15:29 Added PURGE as accepted SQL command starter Renamed the internal purge command to "chop" * 28.03.2006 10:56 Added hash value output to xplain so execution plans can be compared for equality easily * 04.05.2006 09:29 Fixed ps command to work on a cluster, using the GV$ views. Changed the default ordering of "ps" output, so heavy session are displayed last (if -l option is used) * 29.05.2006 16:24 Obsoleted FdStack. Made sure at startup login.sra or login.sql is run but not both. * 29.05.2006 16:25 Added LegacySql and examples. This allows you to use legacy scripts (including Oracle's admin scripts) as senora commands. * 31.05.2006 09:42 Made currentStatement cluster aware (GV$ views Made waits cluster aware) * 06.07.2006 16:16 CH REMA tuning Added timings to sql output like Elapsed: prepare+execute = 10 msec; fetch= 3220 msec; total= 3230 msec * 01.09.2006 14:48 Made "locks" cluster aware * 14.03.2007 16:13 Current Statement can now show the real(!) execution plan * 15.03.2007 13:24 Renamed stat to sesstat and anas to stat Improved dbms_stats wrapper ("stat") Added "set nop" for better testing * 16.03.2007 09:02 Added "edit" option for tnsnames * 03.04.2007 14:55 Fixed jobs -r (Broken='Y', not 'T') Fixed small bug in explain plan of current statement * 10.05.2007 15:19 Fixed small bug in desc -l * 15.06.2007 12:49 Fixed "set drop errors" * 19.06.2007 10:21 Added -v option to "ls" (exclude names) * 03.07.2007 10:02 Convert binary doubles into integer to e.g. display "4" instead of "4.0E+000" by default * 29.08.2007 11:22 Added DataDictionary.codeLine to view selected parts of source code * 12.09.2007 09:49 Added options -A (active) -U (user sessions) to ps command# * 19.02.2008 13:27 Fixed bug in Tuning.currentStatement: it showed the prev statement when asked to also show the execution plan. * 03.03.2008 14:26 Disabled readline support for Windows. A Backspace caused access violation when compiled with perl2exe * 17.04.2008 09:39 Changed the rebuild_indexes (rix) command so partitioned indexes are properly handled * 04.08.2008 13:53 Fixed small bug in SystemTools.genDrop * 04.11.2008 10:19 Added -s option to openCursors to show only one SID * 08.01.2009 11:54 Added the possibility to change the PATH and ORACLE_HOME via an "environment" file to simply using different Oracle versions without having to write a wrapper batch file. This also helps running Senora on 64 bit systems, if you install a 32bit Oracle Instant Client.

  posted 241 days ago

• File released: /senora-production/Senora-1.0.1/SenoraForWindows101.zip

  posted 241 days ago

• Tracker artifact added

  Anonymous created the sysdba connection artifact

  posted by nobody 1560 days ago