Application freezes when sending notices


	Applies To

	Product(s):	Exor TMA Noticing Manager
	Version(s):	4.3.0.0
	Environment:	N/A
	Area:	Works
	Subarea:	N/A
	Original Author:	Bentley Technical Support Group

Problem

Application freezes/is slow when sending a notice

Solution

There shouldn’t really be much of a delay when sending a notice but if there is then it could indicate a problem with your database or server.

The first thing to try would be to refresh the Oracle database statistics by logging in to SQLPlus as the Highways Table Owner and run the following SQL:
begin
dbms_stats.gather_schema_stats(USER);
end;

If there is still a problem then ask your DBA to monitor the database and check that enough resource is given to the shared pool etc and also that the server itself has enough memory. Another thing to check is that there isn’t a large number of hanging sessions.

If you have any bespoke triggers please disable them to check that they aren’t causing the problem.

If you still have a problem then try restarting the database server – remember you must first stop the web server and only start it again once the database has been started again.
Problem 60806