Topic: Performance time limit
Hello, I address for council about a following question:
There is some which launches stored procedure in which some actions in a cycle are fulfilled, then is launched the materialized representation by means of DBMS_MVIEW. The problem consists that the system tests productivity procorfs, and under certain circumstances can pour out in the durable waiting of its end and a brake.
In this connection, it would be desirable to have possibility to stop after a certain time interval, a principal condition should be that procedure in which it is fulfilled , should stop the operation on the outflow of led out time, up to sessions. While two decisions: or somehow periodically to check how many on time procedure in which it is launched is already fulfilled, or somehow to restrict itself on time. But specific implementation, unfortunately, is not present. It would be desirable to hear your judgements on this question. And still a small question: what in your opinion a necessary minimum of skills of optimization for programmer Orakl? If that, the version of Oracle DB 11.2. Thanks!