Log EVERY SINGLE SQL/PLSQL Sent

[RobertK]

Is there a way to ensure the logging of every single SQL/PLSQL sent to Server, in my version or newer version ?
(regradless of which application "window")

 

[patch]

You can find a (freeware) tool for this at TOADWorld.http://www.toadworld.com/DOWNLOADS/ExclusiveToadWorldFreeware/tabid/78/TID/282/cid/64/Default.aspx
Hope this helps.
Kindest regards,
Patrick

 

[Roeland]

You can find a (freeware) tool for this at TOADWorld.http://www.toadworld.com/DOWNLOADS/ExclusiveToadWorldFreeware/tabid/78/TID/282/cid/64/Default.aspx
Hope this helps.

It doesn't. At my site it freezes PL/SQL Developer randomly.

I hope this request becomes a feature of PL/SQL Developer one day.

Roeland

 

[Worker]

If you're trying to debug a problem, there's the "debugsql" parameter. Alternatively you can use a program like Wireshark to capture all Sql*Net traffic.

 

[RobertK]

If you're trying to debug a problem,

No, No just pure and simple thing - logging/recording ALL SQL/PL-SQLs sent --- that's all.
I don't know why the AA guys don't f-ing get it.

Some of us do nothing but run all sorts of queries all day long y'know and just want to keep track of them....

Thanks for the suggestion

 

[RobertK]

You can find a (freeware) tool for this at TOADWorld.

Oh, yes, I tried this some months ago. Stopped using it because:
1) Must launch it separately
2) it logs PLSQLDevelopers queries too, absolutely everything --- too much data

It's ridiculous the PLD does not have this feature PLUS "Named SQL" (right now it takes a plug-in) built in.