Name | Modified | Size | Downloads / 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;