How to check and disable Adaptive Cursor Sharing in 11g

weixin_33948416

于 2017-11-12 15:42:00 发布

阅读量77

点赞数

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/525881

本文介绍如何通过更改参数_optimizer_adaptive_cursor_sharing来禁用Oracle数据库中的自适应游标共享(ACS)功能。该参数可在运行时进行调整，并立即应用于现有会话。文中还提到了两个新的V$sql视图列IS_BIND_SENSITIVE和IS_BIND_AWARE，用于指示游标的敏感性和感知状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

_optimizer_adaptive_cursor_sharing=false disables the feature. There are 2 new columns in V$sql , IS_BIND_SENSITIVE and IS_BIND_AWARE that indicate the status for individual cursors. 1.) The parameter "_optimizer_adaptive_cursor_sharing" can be changed "on the fly". This means if you issue an 'alter system set "_optimizer_adaptive_cursor_sharing" = false |true; ' will be reflected in any existing session. Remember, to disable ACS in 11g ,you should also set alter

本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277502