Toad Query Log

Toad for Oracle & DevOps Toolkit
1

Hi,
I would like to know how, in Toad, can I see query that the software lauch to show the requested data.

Example: In Toad, I go to Users and then I go to Object Grants. Toad has lauched queries to the database to get the requested information, is there a log somewhere of those queries.

I am currently using version 10 of Toad for Oracle.

Thanks.

2

Thanks to me…

Go into View and make sure “Output Window” is displpayed (bottom window). Right click next to the “General” tab and select “Spool SQL to Screen”.

There you go, all queries launched by Toad are displayed.

  • There are option to clear, copy, close when right-clicking on the “Spool SQL” tab.
3

On 22/11/11 16:33, WilliamPP wrote:

Message from: WilliamPP

Thanks to me....

Go into View and make sure "Output Window" is displpayed (bottom
window). Right click next to the "General" tab and select "Spool SQL to
Screen".

There you go, all queries launched by Toad are displayed.

  • There are option to clear, copy, close when right-clicking on the
    "Spool SQL" tab.

Alternatively:

Start->Programs->Quest Software->Toad for Oracle->Tools->SQLMonitor

When it starts, select Toad on the left, and click the button to trace.

Now everything you do in Toad shows up in the monitor window, can be
saved to a file, etc. Plus, it runs quietly in the background and
doesn't clog up Toad's output window with SQL traces.

--
Cheers,
Norm. [TeamT]

4

There you go, all queries launched by Toad are displayed.

Not quite all… but the lion’s share of them for sure.

For example… If you actually need to trace what’s happening to your
session upon login, Norms suggestion to use SQL monitor will catch this.

Caveat: the above is from experience with an earlier version of Toad… not
sure if it still holds true.

Roger S.

5

Thanks guys, very helpfull.

I had to do some research cause it doesn’t seems to be called SQL Monitor anymore but SQL Tracker. I’ve looked in the documentation and got the link to the video that shows how to use the tracker. Exactly what I was looking for.

Thanks again for your help.

Regards,
William

6

You could use the SQL Tracker/Monitor application that gets installed with your
Toad application.

RAS

7

Sorry to ressurect an old thread, but this option does not appear to be available.

There is no “General” tab in the output window.

Running Toad for MySQL 6.3.0.642 on Windows 7 64bit.

In NaviCat you could “View History Log” and see a list of everything executed on the server, even when editing data in the grid in the form of partial inserts.

This is incredibly useful, so still stumped on a way to do this in Toad, any suggestions welcomed!!

8

Oops. Accidental double post!

Message was edited by: Denyerec