大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说ORA-27468: “”.”” is locked by another process「建议收藏」,希望您对编程的造诣更进一步.
You have a scheduler job that generated an error. When the error occurred, you attempted to disable the job to investigate the error, but received an ORA-27468 error message.
27468, 00000, “”%s.%s” is locked by another process”
// *Cause: An attempt was made to read or modify the state of the named
// scheduler object when another process was also updating the same
// object and held the lock.
// *Action: Retry the operation. Scheduler locks are held for a very
// short duration. If the error persists, contact Oracle Support.
Since the documentation for this message said to try again later, you waited, but have continued to receive the same error message.
To implement the solution, please execute the following steps:
1. Check the value for the job_queue_processes:
SQL> show parameter job
NAME TYPE VALUE
———————————— ———– ——————————
job_queue_processes integer 1000
SQL>
2. Stop the cjq0 process.
SQL> show parameter job
NAME TYPE VALUE
———————————— ———– ——————————
job_queue_processes integer 1000
SQL> alter system set job_queue_processes=0;
System altered.
SQL> show parameter job
NAME TYPE VALUE
———————————— ———– ——————————
job_queue_processes integer 0
SQL>
This may require a kill -9 if on Unix or Linux.
3. Drop the problematic job.
4. Restart the cjq0 process.
Reset the job_queue_processes back to the original setting (from show parameter command) using
SQL> alter system set job_queue_processes=<old value>;
摘自：文档 ID 330725.1
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/11047.html
