Print Thread
Oracle Monitor 64 bit
#49516 09/08/14 09:40 AM
Joined: Jan 2004
Posts: 59
G
giga Offline OP
Member
OP Offline
Member
G
Joined: Jan 2004
Posts: 59
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.

Re: Oracle Monitor 64 bit
giga #49521 09/09/14 12:39 PM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
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.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.052s Queries: 15 (0.006s) Memory: 2.4974 MB (Peak: 3.0398 MB) Data Comp: Off Server Time: 2024-04-19 14:00:32 UTC
Valid HTML 5 and Valid CSS