本站中文解释
Oracle视图USER_ADVISOR_EXECUTIONS用于查询及管理已经执行的优化器提示。
里面的内容包括提示的类型，分析模式，建议的收益以及实际采取措施的用户名等。
使用方法：
1、查看可查询的字段：SELECT * FROM USER_ADVISOR_EXECUTIONS;
2、查看特定用户执行的优化提示：SELECT * FROM USER_ADVISOR_EXECUTIONS WHERE USER_NAME=’xxxx’;
3、查看优化器提示的收益：SELECT ADJUSTMENT_COST_BENEFIT FROM USER_ADVISOR_EXECUTIONS;
4、查询范围更广的优化提示：SELECT * FROM USER_ADVISOR_EXECUTIONS WHERE TYPE LIKE ‘%xxxx’;
官方英文解释
USER_ADVISOR_EXECUTIONS displays metadata information for tasks owned by the current user. Its columns (except for OWNER) are the same as those in DBA_ADVISOR_EXECUTIONS.
See Also:
“DBA_ADVISOR_EXECUTIONS”
