There are two ways to use dynamic sampling:
- The
OPTIMIZER_DYNAMIC_SAMPLING parameter can be set at the database
instance level and can also be overridden at the session level with the
ALTER SESSION command.
- The DYNAMIC_SAMPLING query hint can be added to specific queries.
实际使用中,第一种其好处就是不用修改程序,但可能带来潜在的问题,因为开启这个参数后
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/27378/viewspace-559814/
,如需转载,请注明出处,否则将追究法律责任。