MON$STATEMENTS.MON$STATE 的值代表什么？
查询 FB 2.5 RC3 服务器时，我可以在上述字段中看到值 0、1、2。但发行说明只描述了 0 和 1。2 是什么意思？
Querying against FB 2.5 RC3 server I can see values 0, 1, 2 in the mentioned field. But release notes describe only 0 and 1. What does 2 mean?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为它可能在处理选择之后、但在到达数据末尾并释放语句之前处于空闲状态，如以下链接所述：
增强 MON$STATEMENTS / MON$STATE 以表示真实的 CPU 消耗，
这是在 2.5 Beta 1 版本中引入的，如 发行说明 - Firebird Core - 版本 2.5 Beta 1
不太确定是否真的按照错误报告的建议添加，但他们也谈到了状态 3，该状态在数据检索期间将处于“活动”状态。您可以随时在 Firebird 邮件列表中询问，您可以在 Firebird 列表和新闻组。
此致
I think it might be Idle after processing select, but before reaching end of data and releasing the statement as stated in the following link:
Enhance MON$STATEMENTS / MON$STATE to represent real CPU consumption
which was introduced in the 2.5 Beta 1 release as shown in Release Notes - Firebird Core - Version 2.5 Beta 1
Not quite sure if it was really added as the bug report suggested, but they also speak about a state 3 which would be Active during data retrieval. You could always ask in the Firebird mailing list which you can find at Firebird Lists and Newsgroups.
Best regards