[Home] [Help] [Dependency Information]
Object Name: | DBA_SQL_PROFILES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
set of sql profiles
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 |
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;
|
|
|