Oracle 视图 USER_ADVISOR_EXECUTIONS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图USER_ADVISOR_EXECUTIONS用于查询及管理已经执行的优化器提示。
里面的内容包括提示的类型，分析模式，建议的收益以及实际采取措施的用户名等。

使用方法：
1、查看可查询的字段：SELECT * FROM USER_ADVISOR_EXECUTIONS;
2、查看特定用户执行的优化提示：SELECT * FROM USER_ADVISOR_EXECUTIONS WHERE USER_NAME=’x’;
3、查看优化器提示的收益：SELECT ADJUSTMENT_COST_BENEFIT FROM USER_ADVISOR_EXECUTIONS;
4、查询范围更广的优化提示：SELECT * FROM USER_ADVISOR_EXECUTIONS WHERE TYPE LIKE ‘%x’;

官方英文解释

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.