Posted By: giga Oracle Monitor 64 bit - 09/08/14 09:40 AM
How can I monitor the queries made by 64 bit application. The monitor works only for 32 bit applications.

I have problem with the performance:

When I run 32 bit app the query for a report takes 1 second.
When I compile the code as 64 bit it takes 20 seconds and the mouse pointer changing many times to SQLWait that's why I need to monitor the queries to find out what happens.
Posted By: Marco Kalter Re: Oracle Monitor 64 bit - 09/09/14 12:39 PM
The Oracle Monitor is only available as a 32 Bit version.

Such performance differences are usually caused by Oracle Client configuration differences. Can you verify if the 20 second delay is caused by TOracleSession.LogOn or TOracleSession.Connected := True?

For more detailed performance diagnostics you can use the global LogActivity event. Documentation with a complete example can be downloaded here.
© Allround Automations forums