How many CPU shares can be used by a SQL statement in a Low database service?

In the context of Oracle Autonomous Database on shared infrastructure, the concept of CPU shares refers to the amount of processing power allocated to a specific workload or SQL statement within the database service. For the Low database service tier, it is specifically set to allow a maximum of 1 CPU share for each SQL statement.

This limitation is designed to ensure that resources are distributed appropriately among multiple workloads and to maintain performance stability across the database environment. Users operating on the Low tier can still execute queries and workloads effectively, but they will have a constrained amount of CPU resources compared to higher service tiers, which can accommodate more CPU shares. Thus, understanding these allocations helps users optimize their query design and overall database usage within the constraints of the Low database service.