Toad World® Forums

Where can SQL Monitor be downloaded from these days?

Hi All

I have an ooold app that uses oracle client 9/database 9 and it really needs rewriting, but we dont’ have the source and it’s not in a decompilable language, so we were really hoping to see the SQLs it calls and shortcut most of them or adapt them to be faster and part of a .net app, move to 11g etc…

I’ve read blog posts from as recent as 2 years ago and it seems like SQL Monitor would be massively helpful to this end, but I cannot find it for download anywhere. Can someone advise where I can get it?

Thanks
Mark

bump!

When you buy Toad it is part of the package as far as I know. Or you start a
trace and analyze the trace with tkprof.

Groetjes,
Wim

On Thu, Jul 28, 2011 at 14:36, cjard_593 wrote:

Message from: cjard_593

bump!

_______________________________________

Historical Messages

Author: cjard_593
Date: Thu Jul 28 05:36:19 PDT 2011
bump!
__

Author: cjard_593
Date: Tue Jun 21 00:48:20 PDT 2011

Hi All

I have an ooold app that uses oracle client 9/database 9 and it really needs
rewriting, but we dont' have the source and it's not in a
decompilable language, so we were really hoping to see the SQLs it calls and
shortcut most of them or adapt them to be faster and part of a .net app,
move to 11g etc..

I've read blog posts from as recent as 2 years ago and it seems like SQL
Monitor would be massively helpful to this end, but I cannot find it for
download anywhere. Can someone advise where I can get it?

Thanks
Mark

__
_______________________________________

And the toad trace file browser – which is much more powerful than the
simple tkprof – plus tkprof has known issues with showing wrong data types
and thus implicit dt conversions

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:01

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:01

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.015


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

:V001=[

‘50’]

:V002=[

‘50’]

:V003=[

‘50’]

:V004=[

‘019’]

:V005=[

‘00000001’]

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

:V001=[

‘019’]

:V002=[

‘00000001’]

Elapsed time: 0.000


Timestamp: 28/07/2011 14:16:12

COMMIT

Elapsed time: 0.000

ok, so i d/l the trial, opened toad, went to database menu>>monitor>>sql tracker
another window appears, and i select my c++ app i want to monitor (we need to see what it does) while it is running its sets of SQLs…

but all I see in the monitor log is a load of blanks, and occasionally something that looks like bind variables… (note that i started monitoring after I started the process the app is doing)

did I do something wrong? :