Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_SQL_PROFILES

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

Column Datatype NULL Description
NAME VARCHAR2(30) NOT NULL Name of the SQL profile
CATEGORY VARCHAR2(30) 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 DATE NOT NULL Timestamp when the SQL profile was created
LAST_MODIFIED DATE NOT NULL Timestamp when the SQL profile was last modified
DESCRIPTION VARCHAR2(500)   Text description provided for the SQL profile
TYPE VARCHAR2(9)   Type of the SQL profile (how it was created):
  • MANUAL

  • AUTO-TUNE

STATUS VARCHAR2(8)   Status of the SQL profile:
  • ENABLED

  • DISABLED

  • VOID



See Also:

The DBMS_SQLTUNE package in PL/SQL Packages and Types Reference