[Home] [Help] [Dependency Information]
Object Name: | USER_ASSOCIATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All assocations defined by the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_OWNER | VARCHAR2 | (128) | Yes | Owner of the object for which the association is being defined |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Object name for which the association is being defined |
COLUMN_NAME | VARCHAR2 | (128) | Column name in the object for which the association is being defined | |
OBJECT_TYPE | VARCHAR2 | (9) | Schema type of the object - table, type, package or function | |
STATSTYPE_SCHEMA | VARCHAR2 | (128) | Owner of the statistics type | |
STATSTYPE_NAME | VARCHAR2 | (128) | Name of Statistics type which contains the cost, selectivity or stats funcs | |
DEF_SELECTIVITY | NUMBER | Default Selectivity if any of the object | ||
DEF_CPU_COST | NUMBER | Default CPU cost if any of the object | ||
DEF_IO_COST | NUMBER | Default I/O cost if any of the object | ||
DEF_NET_COST | NUMBER | Default Networking cost if any of the object | ||
INTERFACE_VERSION | NUMBER | Interface number of Statistics type interface implemented | ||
MAINTENANCE_TYPE | VARCHAR2 | (14) | Whether it is system managed or user managed |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_OWNER
, OBJECT_NAME
, COLUMN_NAME
, OBJECT_TYPE
, STATSTYPE_SCHEMA
, STATSTYPE_NAME
, DEF_SELECTIVITY
, DEF_CPU_COST
, DEF_IO_COST
, DEF_NET_COST
, INTERFACE_VERSION
, MAINTENANCE_TYPE
FROM SYS.USER_ASSOCIATIONS;
|
|
|