Oracle教程 2023-03-27

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

本站中文解释

Oracle数据库中的视图DBA_SQL_PROFILES显示当前用户拥有的SQL数据库概要等细节。它是一个数据字典视图，列出当前用户拥有的SQL数据库概要和其他有用的运行时参数。

要使用DBA_SQL_PROFILES视图，用户必须具有“SELECT ANY DICTIONARY”数据字典权限。以下语句查询DBA_SQL_PROFILES视图：

SELECT * FROM dba_sql_profiles;

此语句将显示当前用户拥有的SQL概要的细节，以及其他有用的运行时参数。

官方英文解释

DBA_SQL_PROFILES displays information about SQL profiles currently created for specific SQL statements.

Column	Datatype	NULL	Description
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the SQL profile
`CATEGORY`	`VARCHAR2(128)`	`NOT NULL`	Category of the SQL profile
`SIGNATURE`	`NUMBER`	`NOT NULL`	Unique identifier generated from normalized SQL text
`SQL_TEXT`	`CLOB`	`NOT NULL`	Un-normalized SQL text
`CREATED`	`TIMESTAMP(6)`	`NOT NULL`	Timestamp when the SQL profile was created
`LAST_MODIFIED`	`TIMESTAMP(6)`		Timestamp when the SQL profile was last modified
`DESCRIPTION`	`VARCHAR2(500)`		Text description provided for the SQL profile
`TYPE`	`VARCHAR2(7)`		Type of the SQL profile (how it was created): `MANUAL` `AUTO`
`STATUS`	`VARCHAR2(8)`		Status of the SQL profile: `ENABLED` `DISABLED` `VOID`
`FORCE_MATCHING`	`VARCHAR2(3)`		If `YES`, this causes SQL Profiles to target all SQL statements which have the same text after normalizing all literal values to bind variables. If a combination of literal values and bind variables is used in the same SQL text, then no transformation occurs. This is analogous to the matching algorithm use by the `FORCE` option of the `CURSOR_SHARING` parameter. If `NO`, literals are not transformed. This is analogous to the matching algorithm used by the `EXACT` option of the `CURSOR_SHARING` parameter.
`TASK_ID`	`NUMBER`		Advisor task ID that generated the SQL profile
`TASK_EXEC_NAME`	`VARCHAR2(128)`		Advisor execution name for the SQL profile
`TASK_OBJ_ID`	`NUMBER`		Advisor object ID for the SQL profile
`TASK_FND_ID`	`NUMBER`		Advisor finding ID for the SQL profile
`TASK_REC_ID`	`NUMBER`		Advisor recommendation ID for the SQL profile
`TASK_CON_DBID`	`NUMBER`		Database ID for the PDB tuning task generating the SQL profile

本站中文解释

官方英文解释

相关推荐