Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, amol.

Asked: November 12, 2017 - 1:57 pm UTC

Last updated: March 20, 2025 - 2:05 am UTC

Version: Oracle 12c

Viewed 1000+ times

You Asked

Hi Tom,

While doing sql query tuning I came across SQLT Tool and I found it very useful. But there's one problem. Our clients (esp. client's DBAs) are not ready to allow me to use it on their production environment. I told them that it won't have any adverse impact like SQLT's schema growing big in size (as we get purge scripts and also I can drop entire SQLT and re-create it), slowing down DB/HOST while SQLT report is getting generated etc. I also told them that it won't need any separate license. So Tom, my question is how can I persuade them to use SQLT and if there are some side effects SQLT can produce on production environment. Also, if possible please tell if there's any pl/sql code snippet which will produce some what kind of similar output like SQLT (not necessarily to give HTML output) which will help me for doing query tuning.

Thank you so much for doing great work and helping Oracle Community,
Amol V. Palav

and Connor said...

I would point them at MOS Note 215187.1

In particular, point out:

"SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise"

This is not some thrown together 3rd party tool. It is one that has been written by some of the best resources inside the Oracle organization.

But ultimately, it's a sad reality that we often run into roadblocks against people who say "no" simply because the don't have an appropriate understanding of the technology they claim to be proficient in. All I can advise is patience. Perhaps try showing some examples of SQLT in action against a non-production database, or ask them what tools *they* are using, to at least get a dialog going.

If that doesn't work, you can always try throwing a chair at them :-) (just kidding).

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Useful suggestions

Amol, November 13, 2017 - 6:26 am UTC

Hi Connor,

Thank you so much for your advice (esp. of that chair one). Next time I will come across such situations, I will surely approach them with line "provided by Oracle Server Technologies Center of Expertise" and bunch of sample reports.

Once again thank you so much.
Amol V. Palav

add SQL to DBCA

Pierre, March 11, 2025 - 12:48 pm UTC

Sometimes I feel that Oracle could make life easier for its customers: SQLT could be some kind of DBCA option and that would fix this kind of issue.
Connor McDonald
March 20, 2025 - 2:05 am UTC

agreed
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.