Oracle SQL Tuning Tools and Tips

SQL Tuning, eAdam, eDB360, SQLT, SQLHC

How to know what is the installed SQLTXPLAIN version

with one comment

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)

One Response

Subscribe to comments with RSS.

  1. 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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,388 other followers

%d bloggers like this: