1. 首页
  2. IT资讯

补充:小心设置cursor_sharing=force参数

转载自:http://www.itpub.net/351520,2.html
摘自:expert one-on-one oracle  (P554)
設置cussor_sharing=force之後,會有以下的情況:
• Optimizer related issues – CURSOR_SHARING will remove all character string
and numeric constants from the query; the optimizer will have less information to
work with. This may very well result in different query plans.
• Query output related issues – The lengths of columns that your query fetches will
unexpectedly change. Queries that used to return a VARCHAR2(5) and a
NUMBER(2), might start returning a VARCHAR2(30) and a NUMBER(5). The
actual size of the data returned wonʹt change, but the application will be told the
potential for a 30 byte column is there – reports and other related applications may
be affected.
• Query plans are harder to evaluate – This is due to the fact that EXPLAIN PLAN
will ʹseeʹ a different query than the database does. This makes query tuning more
difficult. Features like AUTOTRACE in SQL*PLUS are unreliable with
CURSOR_SHARING.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-82784/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183056.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code