DBA_ASSOCIATIONS

Tuesday, September 23, 2008

DBA_ASSOCIATIONS describes all user-defined statistics in the database. Its columns are the same as those in ALL_ASSOCIATIONS.

Related Views

· ALL_ASSOCIATIONS describes user-defined statistics associated with objects accessible to the current user.

· USER_ASSOCIATIONS describes user-defined statistics associated with objects owned by the current user.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object for which the association is being defined
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object for which the association is being defined
`COLUMN_NAME`	`VARCHAR2(30)`		Column name in the object for which the association is being defined
`OBJECT_TYPE`	`VARCHAR2(9)`		Kind of object with which statistics are being associated: column, type, package or function, indextype, or domain index.
`STATSTYPE_SCHEMA`	`VARCHAR2(30)`		Owner of the statistics type
`STATSTYPE_NAME`	`VARCHAR2(30)`		Name of statistics type that contains the cost, selectivity or statistics functions
`DEF_SELECTIVITY`	`NUMBER`		Default selectivity of the object, if any
`DEF_CPU_COST`	`NUMBER`		Default CPU cost of the object, if any
`DEF_IO_COST`	`NUMBER`		Default I/O cost of the object, if any
`DEF_NET_COST`	`NUMBER`		Default networking cost of the object, if any
`INTERFACE_VERSION`	`NUMBER`		Identifies the version number of the `ODCIStats` interface. Value is `1` for statistics type implementing Oracle8i 8.1; `0` for types implementing Oracle9i 9.0.0.
`MAINTENANCE_TYPE`	`VARCHAR2(14)`		Specifies whether the object is system-managed or user-managed

1. Query the user-defined statistics in the database.

select * from DBA_ASSOCIATIONS;