For those of you who like the Trace File Browser

Toad for Oracle - Beta
1

I want to share with you something that will be in the next beta.

The Trace File Browser in 16.3 and prior has this button to pull trace files from the server.

image
image676×573 29.1 KB

It's nice because you don't have to FTP or otherwise go to the server in some old fashioned way (did you just think of that song by The Police?), but has the following limitations:

  1. Workflow isn't clear
  2. Sometimes the files you get back aren't SQL trace files, they are just memory dump-style trace files that don't contain any SQL.
  3. You can't filter by file contents.
  4. Filtering by date range can only be accomplished using the grid filter
  5. You can't peek into any of the files to find out anything about their contents before you load them into Trace File Browser.

So I re-worked that dialog. I'm really pleased with the result.

Here's a video. It was too big to paste here so I put it on YouTube.

1 Like
2

Hi, have an error with new workflow:

-- ORA-06550: line 34, column 25:
PLS-00306: wrong number or types of arguments in call to 'TO_CLOB'
ORA-06550: line 34, column 7:
PL/SQL: Statement ignored

The line is in proc CheckContents:

if dbms_lob.Instr(to_clob(p_content), 'PARSING IN CURSOR') < 1 then
3

Hi Tenorio,

Thank you. I can reproduce that on versions less than 19c and will fix.

-John

4

I don't say it often about enhancements, but game-changer!

1 Like
5

Thanks Chuck, that made my day.