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.

SELECT
sqltxplain.sqlt$a.get_param('tool_version') sqlt_version,
sqltxplain.sqlt$a.get_param('tool_date') sqlt_version_date,
sqltxplain.sqlt$a.get_param('install_date') install_date
FROM DUAL;

SELECT
'SQLT version number: '||sqltxplain.sqlt$a.get_param('tool_version')||CHR(10)||
'SQLT version date : '||sqltxplain.sqlt$a.get_param('tool_date')||CHR(10)||
'Installation date : '||sqltxplain.sqlt$a.get_param('install_date') sqlt_version
FROM DUAL;

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.

Written by Carlos Sierra

June 18, 2013 at 2:17 pm

Posted in SQLTXPLAIN (SQLT)

3 Responses

Subscribe to comments with RSS.

Thank you Carlos for both the queries and Oracle Doc. The no-older-than-3-release guidance is helpful too.

Alex Wu

June 18, 2013 at 2:38 pm

Reply
I had a question, is SQLT dependent on the version of Oracle installed? Can I install the latest version of SQLT on the older Oracle version like 11,10,9,8 etc?

Akhil

May 22, 2017 at 9:43 pm

Reply
- You can install SQLT on 10R2-12c. MOS 215187.1 provides also a version for 9i-10R1
  
  Carlos Sierra
  
  May 23, 2017 at 5:59 am
  
  Reply

Carlos Sierra's Tools and Tips