Our team is running into horrible run times due to context switching efficiencies for our queries because of the use of deterministic functions.
The team is split down the middle between allocating more resources to the database and refactoring our entire architecture from deterministic functions to a sort of “deterministic view” approach, as encapsulating the logic thats in the functions into views eliminates the context switching between the PLSQL engine and the SQL engine.