ALL_SQLSET_REFERENCES

Previous Next JavaScript must be enabled to correctly display this content

3.83 ALL_SQLSET_REFERENCES

ALL_SQLSET_REFERENCES describes whether or not the SQL tuning sets accessible to the current user are active.

Related Views

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
`SQLSET_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the SQL tuning set
`SQLSET_OWNER`	`VARCHAR2(128)`		User name of SQL tuning set owner
`SQLSET_ID`	`NUMBER`	`NOT NULL`	Identifier of the SQL tuning set
`ID`	`NUMBER`	`NOT NULL`	Reference identifier
`OWNER`	`VARCHAR2(128)`		User who registered to use the SQL tuning set
`DESCRIPTION`	`VARCHAR2(256)`		Description of the usage of the SQL tuning set
`CREATED`	`DATE`		Date the reference was created

See Also: