Open
Description
We could introduce new annotation that could define a performance criteria regarding time execution of test. E.g. - - %timelimit(5s).
This could fail the test after it passes the criteria regarding of the assertion result.
We should allow to pass probably at least two time units : s as seconds and ms as millisecond.
currently discussed solution was
- use resource manager - this got implications of higher privs required to be granted to framework owner. https://blog.pythian.com/oracle-limiting-query-runtime-without-killing-the-session/
This could be possibly added as optional feature in installation step to allow users who are not able to install with more grants. - executables to start running as plsql tasks https://oracle-base.com/articles/11g/dbms_parallel_execute_11gR2