CPU time limit exceeded

[spneo]

Platform: AIX 4.3.3
oracle version: 7.3.3.0

I am running an oracle process (exp a 40 GB database and compress it at the same time), after the process was running for about 3 hours, it was terminated and an error message show on the screen :

CPU time limit exceeded

Can anyone advice on this matter ? Does this related to the soft CPU time or Hard CPU time in a user profile ?

Thanks.
Neo

 

[MikeLacey]

Hi Neo,

Think this is the Hard CPU Time value, set it to unlimited (-1) and try the job again.

 

[shiraz]

hi
check the limits for user who ran that process...(/etc/security/limits file).
the file contain two attributes
cpu----> indicates soft limits for cpu time
cpu_hard----->indicates hard limits for cpu time
so set them to -1 and rerun the process
you can also use smitty system to check various system attributes like max. number of
processes allowed per user(maxproc).

regds

Shiraz

 

[ElgisRamon]

The same info: try [tt]smit chuser[/tt] to change the soft CPU limit and hard CPU limit of the user running the process. And, don't touch [tt]maxuproc[/tt]! that is a global limit affecting ALL users in the system, excepting root.

I hope it works...