监视Delphi应用程序执行的SQL查询

时间:2022-05-18 15:47:15

I'd like to monitor SQL queries executed by my application while it runs.

我想监视应用程序运行时执行的SQL查询。

I'm using a dbExpress connection to an Oracle 11g database under Delphi 2007.

我正在使用Delphi 2007下的Oracle 11g数据库的dbExpress连接。

This used to be possible under the BDE with the sqlmon.exe utility.

过去可以在BDE下使用sqlmon.exe实用程序。

Is there a similar utility for dbExpress?

dbExpress有类似的实用程序吗?

I've tried the Toad SQL Monitor, which logs two or three queries and then promptly hangs the application. I can set up a full-blown Oracle trace, but that is overkill for everyday debugging.

我尝试过Toad SQL Monitor,它会记录两到三个查询,然后立即挂起应用程序。我可以设置一个完整的Oracle跟踪,但这对于日常调试来说太过分了。

1 个解决方案

#1


To be able to monitor querys, you'll have to use a delegate trace driver.

为了能够监视查询,您必须使用委托跟踪驱动程序。

Read this link, it gives more info on dbexpress 4 and delphi 2007. Note for D2009 users: With D2009, you don't have to tweak ini files anymore, just use the object inspector, it gives the ability to stack up delegate drivers directly in the IDE.

阅读此链接,它提供了有关dbexpress 4和delphi 2007的更多信息。请注意D2009用户:使用D2009,您不必再调整ini文件,只需使用对象检查器,它就可以直接堆叠代理驱动程序在IDE中。

#1


To be able to monitor querys, you'll have to use a delegate trace driver.

为了能够监视查询,您必须使用委托跟踪驱动程序。

Read this link, it gives more info on dbexpress 4 and delphi 2007. Note for D2009 users: With D2009, you don't have to tweak ini files anymore, just use the object inspector, it gives the ability to stack up delegate drivers directly in the IDE.

阅读此链接,它提供了有关dbexpress 4和delphi 2007的更多信息。请注意D2009用户:使用D2009,您不必再调整ini文件,只需使用对象检查器,它就可以直接堆叠代理驱动程序在IDE中。