Home » RDBMS Server » Server Administration » understanding user profile resource parameter CPU_PER_CALL (Oracle Database 19c Enterprise Edition Release
understanding user profile resource parameter CPU_PER_CALL [message #684908] Fri, 24 September 2021 08:56 Go to next message
Messages: 390
Registered: March 2005
Senior Member
i am trying to understand the user profile resource parameter CPU_PER_CALL. basically i know that this has something to do about the amount of CPU that a single SQL statement can be run.

i alter the profile and set the CPU_PER_CALL to 300 -- for 5 minutes
alter profile NYS_ADHOC_PROFILE_00 limit CPU_PER_CALL 300;

then i purposely run a query
select a.* from table_a a, table_b;

in less than 1 minute it throws an erorr:
ERROR at line 1:
ORA-02393: exceeded call limit on CPU usage

was that the default behavior because if i understand it correctly should have been reach 5 minutes before it throws the error. or was it that the optimizer already knows that the query will go beyond the 5 minutes and that is why it throws the error even before the 5 minutes?

Re: understanding user profile resource parameter CPU_PER_CALL [message #684909 is a reply to message #684908] Fri, 24 September 2021 10:27 Go to previous message
Michel Cadot
Messages: 68601
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Make sure the query does not run in parallel mode.

Previous Topic: RMAN backup hangs
Next Topic: log_archive_dest truncate
Goto Forum:

Current Time: Mon Mar 04 16:15:26 CST 2024