Oracle教程 2023-04-03

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

Oracle视图DBA_ADVISOR_TEMPLATES用于查询当前实例中已定义的分析器模本。它存储了系统中分析器模本的基本信息，包括名称、描述、执行顺序、参数和SQL聚合函数。

使用Oracle视图DBA_ADVISOR_TEMPLATES的方法如下：

1. 连接到Oracle数据库：使用SQL *Plus、TOAD或其他数据库管理工具登录到Oracle数据库中；

2. 执行查询：执行查询“SELECT * FROM dba_advisor_templates”以查询当前实例中已定义的分析器模本；

3. 分析模版信息：从DBA_ADVISOR_TEMPLATES视图中的输出中获取关于模版的所有基本信息，如模版名称、描述、执行顺序、参数和SQL聚合函数等。

4. 退出Oracle数据库：退出当前的Oracle数据库连接即可完成查询。

DBA_ADVISOR_TEMPLATES displays information about all templates in the database.

Related View

USER_ADVISOR_TEMPLATES displays information about the templates owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the task
`TASK_NAME`	`VARCHAR2(128)`		Name of the task
`DESCRIPTION`	`VARCHAR2(256)`		User-supplied description of the task
`ADVISOR_NAME`	`VARCHAR2(128)`		Advisor associated with the task
`CREATED`	`DATE`	`NOT NULL`	Creation date of the task
`LAST_MODIFIED`	`DATE`	`NOT NULL`	Date on which the task was last modified
`SOURCE`	`VARCHAR2(128)`		Optional task or template on which the template was based
`READ_ONLY`	`VARCHAR2(5)`		Indicates whether the task can be modified or deleted (`TRUE`) or not (`FALSE`)