How to know what is the installed SQLTXPLAIN version

Every so often I get this question: How do I know what is the version of SQLT installed on my database? You can execute one of the two queries below, connecting as a user with the SQLT_USER_ROLE or the DBA role.

Prior versions and their release date follow. List only includes versions since the 3rd major code version of the tool.

11.4.5.9 June 10, 2013

11.4.5.8 May 10, 2013

11.4.5.7 April 5, 2013

11.4.5.6 March 5, 2013

11.4.5.5 March 1, 2013

11.4.5.4 February 4, 2013

11.4.5.3 December 31, 2012

11.4.5.2 December 12, 2012

11.4.5.1 November 27, 2012

11.4.5.0 November 21, 2012

11.4.4.8 September 27, 2012

11.4.4.7 July 2, 2012

11.4.4.6 June 2, 2012

11.4.4.5 May 2, 2012

11.4.4.4 April 2, 2012

11.4.4.3 March 2, 2012

11.4.4.2 February 2, 2012

11.4.4.1 January 2, 2012

11.4.4.0 December 4, 2011

11.4.3.9 October 30, 2011

11.4.3.8 October 20, 2011

11.4.3.7 October 10, 2011

11.4.3.6 August 16, 2011

11.4.3.5 August 10, 2011

11.4.3.4 July 20, 2011

11.4.3.3 July 14, 2011

11.4.3.2 July 9, 2011

11.4.3.1 June 17, 2011

11.4.3.0 May 20, 2011

11.4.2.7 April 8, 2011

11.4.2.6 March 28, 2011

11.4.2.5 March 20, 2011

11.4.2.4 February 18, 2011

11.4.2.3 January 14, 2011

11.4.2.1 October 24, 2010

11.4.2.0 September 18, 2010

11.4.1.6 August 20, 2010

11.4.1.5 August 4, 2010

11.4.1.4 July 12, 2010

11.4.1.3 June 8, 2010

11.4.1.2 June 3, 2010

11.4.1.1 June 1, 2010

11.4.0.5 May 20, 2010

11.4.0.4 May 6, 2010

11.4.0.3 April 22, 2010

11.4.0.2 April 13, 2010

11.4.0.1 April 11, 2010

Conclusion

Every SQLT release incorporates a set of fixes and enhancements. Actual list of changes can be see out of Metalink/MOS 215187.1. If your installed version is more than 3 releases old (about 3 months), you may want to download and install the latest version. Installation of SQLT on top of any versions from list above does not require an uninstall. In other words, if you install the latest version, your SQLT repository is preserved. SQLT installation takes about 5 minutes.