[X] The "/2009 Vixta Aero 3D/VixtaAero3D.EN.Cd.Mobile7.iso" file could not be found or is not available. Please select another file.

Share

More
Shell environment for oracle Icon

Shell environment for oracle

by drautzburg


Senora is targeted to be a drop-in replacement for sqlplus. It provides a plethora of new commands, which accept unix-style options. It is extensible via plugins.


http://senora.sourceforge.net





Separate each tag with a space.

Release Date:

2009-03-13

Topics:

License:

Ratings and Reviews

  • Thumbs up:

    1
  • Thumbs down:

    0
100% of 1 user recommends this project

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

Project Feed

  • 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

Rate and Review

Would you recommend this project?






<

Related Projects

Shell environment for oracle Actions

Thanks for your rating!

Would you also like to write a review?





Skip Review