Application freezes/is slow when sending a notice
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:begindbms_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
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server