查询Oracle RAC实例数量的官方方法
根据The Oracle FAQ,可以查询SYS.V_$ACTIVE_INSTANCES
并/或 SYS.V_$THREAD
视图来查找活动 RAC 实例的数量。我记得在某处读到过,V_$
视图是 Oracle 内部的,如有更改,恕不另行通知。这是真的吗?是否有“官方”方法可以在存储过程中查找 RAC 数据库中正在运行的实例数?有没有办法找出数据库的 RAC 实例总数(无论是否运行)?
According to The Oracle FAQ, you can query the SYS.V_$ACTIVE_INSTANCES
and/or SYS.V_$THREAD
views to find the number of active RAC instances. I remember reading somewhere that the V_$
views are internal to Oracle and subject to change without notification. Is this true? Is there an "official" way to find the number of running instances in a RAC database in a stored procedure? Is there a way to find out the total number of RAC instances for a database, running or not?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
来自同一个预言机常见问题解答,
是的,“如有更改,恕不另行通知”:有人可以“无需通知”地拔出一台机器的电源线
From the same oracle FAQ,
and yes are "subject to change without notification": someone can draw out the power cable of one machine "without notification"