Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

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

Go to previous page
Go to next page
View PDF


DBA_SQLSET_REFERENCES describes whether or not all SQL tuning sets in the database are active. A SQL tuning set cannot be dropped if it is referenced.

Related View

USER_SQLSET_REFERENCES describes whether or not the SQL tuning sets owned by the current user are active.

Column Datatype NULL Description
ID NUMBER NOT NULL Reference identifier
SQLSET_ID NUMBER NOT NULL SQL tuning set identifier
OWNER VARCHAR2(30)   User who registered to use the SQL tuning set
CREATED DATE   Date the reference was created
DESCRIPTION VARCHAR2(256)   Description of the usage of the SQL tuning set