The Oracle Database excels at managing shared resources among thousands of database users. Oracle Database Cloud Schema Service uses this proven ability to distribute computer resources among tenants.

The Schema Service uses Database Resource Manager consumer groups to prevent any tenant from impacting the performance of other tenants. All tenant operations are initially placed in a consumer group with maximum access to resources. If a user exceeds the resource limitations of this initial consumer group, their user process is pushed to a lower priority user group, with a much longer limit on resource consumption, but a lower priority. If a user process exceeds this limit, they are pushed to a lower priority group with a much higher resource limit.

If a user process should exceed this last limit, the process may be terminated with the ORA-00040: active time limit exceeded - call aborted error. Please be aware that this lowest consumer group allows for the consumption of up to 180 seconds of dedicated CPU time, a threshold which is normally only crossed by runaway processes. If you encounter the ORA-00040: active time limit exceeded - call aborted error, identify the specific SQL operation that is causing it (for example, a query or an update statement) and reduce its complexity.