AQ$_PLSQL_NTFNnnnn 调度程序作业的用途是什么？
我根本不使用高级队列，但 AQ$_PLSQL_NTFNnnnn 调度程序作业的数量不断增长。
目前有8个这样的职位。由于它们 - 我需要刷新最大同时运行作业数。
大约 2 个月前，限制为 10 个还可以，目前我限制为 15 个，并且由于 8 个“不必要”（至少对我来说），所以我需要将其增加到 20 或 25 :-S
那么，什么是他们用来做什么？我可以删除/禁用它们吗？
UPD：我已将并发作业数量增加到 25 个，而在今晚，AQ...作业数量增加到 25 个：-S 这是一个笑话吗？！
I don't use Advanced Queueing at all, but amount of AQ$_PLSQL_NTFNnnnn scheduler jobs grows continuously.
Currently there are 8 such jobs. And because of them - I need to refresh maximum simultaneous jobs running count.
About 2 months ago it was ok with limit of 10, currently I have limit 15 and because of 8 "unnecessary" (at least for me) that jobs - I need to increase it to even 20 or 25 :-S
So, what are they used for? Can I just drop/disable them?
UPD: I've increased number of simultaneous jobs to 25 and in this night the amount of AQ... jobs rose up to 25 :-S Is it a joke?!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在我看来，好像有什么东西正在数据库中的某个地方使用 AQ。
我用谷歌搜索了一下，这里有一些可能有用的信息 - http://www.ora600.be/ node/5547 - 主要是隐藏参数 _srvntfn_max_concurrent_jobs ，它显然限制了为通知而运行的作业总数。
信息似乎很难获得，但显然通知会进入表 sys.alert_qt，因此您可以尝试查看其中显示的内容。
您还可以查看 ALL_QUEUES 和其他 ALL_QUEUE* 表，看看数据库中是否存在您不知道的队列。
我假设您使用的是 Oracle 11gR1 或 11gR2？
It sounds to me like something is using AQ somewhere in your database.
I googled around a bit, and there is some possibly useful information here - http://www.ora600.be/node/5547 - mostly the hidden parameter _srvntfn_max_concurrent_jobs that apparently limits the total number of jobs running for notifications.
Information seems to be hard to come by, but apparently notifications go into the table sys.alert_qt, so you could try having a look in there to see what appears.
You could also have a look in the ALL_QUEUES and other ALL_QUEUE* tables to see if there are any queues on your database you are not aware of.
I am assuming you are using Oracle 11gR1 or 11gR2?
当使用 PL/SQL 回调函数处理 AQ 队列时，我们已经看到生成了这些作业。您可以检查此表以查找任何已注册的订阅：
有关更多信息AQ PL/SQL 回调
When using a PL/SQL Callback function for processing the AQ queue, we have seen these jobs being generated. You can check this table to find any registered subscriptions:
More about AQ PL/SQL Callback