eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SQL_PROFILES

Object Details

Object Name:	DBA_SQL_PROFILES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

set of sql profiles

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(128)	Yes	name of sql profile
CATEGORY	VARCHAR2	(128)	Yes	category of sql profile
SIGNATURE	NUMBER		Yes	unique identifier generated from normalized SQL text
SQL_TEXT	CLOB	(4000)	Yes	un-normalized SQL text
CREATED	TIMESTAMP(6)	(11)	Yes	date stamp when sql profile created
LAST_MODIFIED	TIMESTAMP(6)	(11)		date stamp when sql profile was last modified
DESCRIPTION	VARCHAR2	(500)		text description provided for sql profile
TYPE	VARCHAR2	(7)		type of sql profile (how created)
STATUS	VARCHAR2	(8)		enabled/disabled status of sql profile
FORCE_MATCHING	VARCHAR2	(3)		signature is force matching or exact matching
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			container dbid for the tuning task generating the profile

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      CATEGORY
,      SIGNATURE
,      SQL_TEXT
,      CREATED
,      LAST_MODIFIED
,      DESCRIPTION
,      TYPE
,      STATUS
,      FORCE_MATCHING
,      TASK_ID
,      TASK_EXEC_NAME
,      TASK_OBJ_ID
,      TASK_FND_ID
,      TASK_REC_ID
,      TASK_CON_DBID
FROM SYS.DBA_SQL_PROFILES;

Dependencies

[top of page]

SYS.DBA_SQL_PROFILES references the following:

SYS: SQL$; SQL$TEXT; SQLOBJ$; SQLOBJ$AUXDATA

SYS.DBA_SQL_PROFILES is referenced by following:

PUBLIC: DBA_SQL_PROFILES
SYS: DBMSHSXP - show dependent code; DBMS_FEATURE_AUTOSTA - show dependent code; DBMS_MANAGEMENT_PACKS - show dependent code; DBMS_SQLTUNE - show dependent code; DBMS_SQLTUNE_INTERNAL - show dependent code