i want to retreive trace of sql , which Component I use ,

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
chikh
Posts: 1
Joined: Wed 23 Mar 2005 18:47

i want to retreive trace of sql , which Component I use ,

Post by chikh » Wed 23 Mar 2005 18:51

I try with ToraSQL or toraScript , but it didn't retrieve trace of my sql
like the component of Direct Oracle Access

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Thu 24 Mar 2005 09:28

You can see only debug information about executed SQL such as text of the query
and parameters. You can see it in dialog window if ToraSQL.Debug=true (using
OdacVCL unit) or in DBMonitor, SQLMonitor (using TOraSQLMonitor component).
If you need information about elapsed time or execution plan you can use
OraTools utility.

Post Reply