Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
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.
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 |