Is "create profile X limit cpu_per_call" allowed in Standard Edition?
We have Enterprise Edition for one server and Standard Edition for most, and an internal dispute whether we can use create profile X limit cpu_per_call=18000 and assign that to users to kill long-running sessions related to badly-designed ad-hoc reports.
Resource Manager has more robust limits, and it is Enterprise Edition. An Oracle 10.1 white paper from 2005 says, "Oracle Database 10g continues to support the use of user profiles to implement hard resource limits but the Resource Manager provides a more sophisticated way of managing database resources…" That suggests to me that the profile limit is allowed outside of Resource Manager. The internal consensus is that it’s the resource manager that kills the process once the timer expires, so it's not allowed in Standard Edition.