Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem that ORA-27492 can not run in oracle". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the problem that ORA-27492 can not run in oracle".

Oracle executes homework Times the above error

Solution:

SQL > show parameter job_queue_processes

NAME TYPE VALUE

-

Job_queue_processes integer 0

SQL > alter system set job_queue_processes=1000 scope=both

System altered

SQL >

It should be scope=both and scope=spfile.

There is something called spfile in Oracle, which is a dynamic parameter file, which sets various parameters of Oracle. The so-called dynamic means that you can change the database parameters and record them in spfile without shutting down the database. There are four scope options when changing parameters. Scope is the scope.

+ + scope=spfile only changes the records in spfile, does not change memory, that is, does not take effect immediately, but waits for the next database startup to take effect. Some parameters are only allowed to be changed in this way

+ + scope=memory only changes memory, not spfile. That is, it will be invalid the next time it starts.

+ + scope=both memory and spfile are changed

+ + does not specify the scope parameter, which is equivalent to scope=both.

Thank you for your reading, the above is the content of "how to solve the problem that ORA-27492 can not run in oracle". After the study of this article, I believe you have a deeper understanding of how to solve the problem that ORA-27492 can not run in oracle, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.