正德厚生,臻于至善

oracle 11g禁用和强制direct path read

How To Force Direct Path Read for SQL Statements (Doc ID 2426051.1)

Exadata Smartscan Is Not Being Used On Insert As Select (Doc ID 1348116.1)

--alter system set event='10949 TRACE NAME CONTEXT FOREVER, level 1' scope=spfile; 
SQL> alter system set "_serial_direct_read"=false scope=both sid='*'; 
SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
  FROM SYS.x$ksppi x, SYS.x$ksppcv y
 where x.indx = y.indx
   AND (x.ksppinm = '_small_table_threshold' or
       x.ksppinm = '_serial_direct_read');

https://www.cnblogs.com/zhjh256/p/9506247.html

赞(0) 打赏
未经允许不得转载:徐万新之路 » oracle 11g禁用和强制direct path read

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏

登录

找回密码

注册