Download Latest Version SqlPlusScript-0.7.0.zip (819.8 kB)
Email in envelope

Get an email when there's a new version of SqlPlusScript

Home / 0.2.0
Name Modified Size InfoDownloads / Week
Parent folder
readme.txt 2017-03-31 740 Bytes
sqlps-0.2.0.zip 2017-03-31 554.0 kB
Totals: 2 Items   554.8 kB 0
Version 0.2.0

Added scripts:
- to view dependencies between database objects ( dependency.sql, reference.sql);
- to view blocking sessions ( Session/block.sql);
- to view blocking sessions on objects in the library cache ( Session/library-block.sql);
- to view SQL execution plan that is executed in session ( Session/plan.sql);
- to kill session ( Session/kill.sql);
- to start or stop spooling to file ( Common/spool-on.sql, Common/spool-off.sql);

Refactoring use of query options:
- use the option "1" instead of "o" to select at most one record;
- discontinued use of "with", which improved the query execution plan in some cases;
- substitute variables and delete extra lines in base query;
- query of variables 3, 4, 5 is excluded;
Source: readme.txt, updated 2017-03-31